Oracle Stored Procedure Snap error
Hi SMEs,Good day, any idea what is the root cause of this error? checked the stored procedure and all fields have alias. Thanks,EmEm
Forum Posts
CSV Formatter not allowing ISO-LATIN-1
I am unable to set a CSV Formatter snap to use ISO-LATIN-1 character encoding. All other options from the "Character set" drop-down list work without problem, but choosing ISO-LATIN-1 makes the snap fail with the following error:Failure: ISO-LATIN-1,...
In-memory lookup or Join functionality not working as expected.
I have a data present in CSV file and I have user input parameter.I want to get the complete record that matching with one of the column value in CSV to the input parameter.Like in below screenshot, my input parameter is Role3 and it is matching with...
Paginating Triggered Task Results
Hello everyone.How can we configure a pipeline which is called using a triggered task and returns and json payload to have paginated results?The API call to the pipeline currently passes in parameters of which some are used in the call to a database ...
Resolved! How to create timestamps and out put them only using Script snap for Python?
I need to generate timestamps using Script snap for Python. I tried to use datetime and java.sql.Timestamp but Type Inspector recognizes them as java.util.LinkedHashMap and the operator instanceof returns false for DateTime and LocalDateTime. Is it p...
group by function
i am unable to use the group by function using the sql snap. can anyone help
Snowflake SCD2 - malformed date issue
Hi Team,Can anyone please help me in the following issue which I'm facing with "Snowflake - SCD2" snap.As per my requirement, I have to load the timestamp data into the table (we are receiving the input date data in 12hour format). In the Snowflake t...
Issue with Snowflake - SCD2 snap in SnapLogic
Hi Team,Can anyone please help me in the following issue which I'm facing with "Snowflake - SCD2" snap.As per my requirement, I have to implement SCD Type2, to achieve this I'm using "Snowflake - SCD2" snap in SnapLogic pipeline. In this snap I'm usi...
