This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
Mark
New Contributor II
since ‎11-25-2020
‎07-25-2023

User Statistics

  • 12 Posts
  • 1 Solutions
  • 1 Kudos given
  • 1 Kudos received

User Activity

Excel Formatter - need date datatype with this format MM/DD/YYYY

03-09-2022
Im using Excel Formatter. I am selecting from Oracle. I need the column in excel to be date datatype, but have this format MM/DD/YYYY with no time on the end. I can get the date into that format if I do a to_char(mydate, ‘MM/DD/YYYY’) in the select...

Is there a way to generate Excel files and not write them to disk?

03-08-2022
I have and Excel Formatter and a Rest Post Snap. I want to send the Excel File in the Rest Post Snap. Why do I have to write the Excel file to disk first? Can I create the Excel file in memory and pass that to the Rest Post Snap somehow without go...

Get current JSON document being inserted

01-12-2022
I have a pipeline with a oracle insert snap and a error pipeline. Everything works. When something in the pipeline fails I am passing variables to the error pipeline and storing in a table. I want to pass the current JSON document that failed? W...

Implied commit after oracle delete snap

12-09-2020
I have a ETL pipeline. I want to do delete from table; insert into table; commit; but the oracle delete snap has a implied commit after it so I get delete; commit; insert; commit. My table is sitting there blank with no records until all the inse...

Controlling Auto Commit

11-25-2020
I have a pipeline with a jdbc execute with a select sql from source (postgres), Oracle Delete of target table, Oracle insert of target table. I turn auto commit off in the target oracle account. But for some reason after the Oracle Delete snap Sna...
Kudos from
Kudos given to