Drop few columns before inserting into Oracle table

Question

I am reading data from csv file before inserting the data into Oracle table,I want to delete or omit unnecessary columns. How to achieve this?Thanks in advance

cstewart · Answer

If you put a mapper Snap in between, you can put the source fields in the source column, if you put no target for those fields, it will drop them in the data flow. Use the pass-through option to get all other fields passed to the output without having to put them all in the table

siva_venna · Answer

Thanks @cstewart. It worked.
I am getting below error while inserting data into Oracle table :
Invalid timestamp format:
Resolution:
Please check for valid timestamp format.
My coulmn datatype is DATE.
The timestamp snaplogic fetching : 2019-03-20T13:03:45+00:00
how to convert the this timestamp to Oracle DATE datatype?

pedro_almeida · Answer

As I see it, you have 2 options:

Add an “Oracle Delete” Snap without any delete condition (DELETE FROM TableName) before inserting the data.
If you really need to execute the Truncate instead of the Delete, you may try to create a stored procedure (On your Oracle DB) with “EXECUTE IMMEDIATE 'TRUNCATE TABLE ’ || TableName;” statement and then call this stored procedure on SnapLogic with the “Oracle Stored Procedure” Snap.

I would go for option 1 for simplicity.

dmiller · Answer

This post might help: SnapLogic DateTime Conversion Guidelines

siva_venna · Answer

Thank you @dmiller
that post helped me.
I want to truncate the table before loading/ inserting the data for every execution. is it possible?

Forum Discussion

Drop few columns before inserting into Oracle table

Recent Discussions

Pagination and nextCursor in header

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM