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
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Drop few columns before inserting into Oracle table

Siva_Venna
Contributor

‎03-19-2019 08:12 AM

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

0 Kudos
8 REPLIES 8

dmiller
Admin Admin
Admin

‎03-26-2019 05:36 AM

You can use the Mapper Snap.
If you put the source fields in the source column and do not specify a target for those fields, it will drop them in the data flow.


Diane Miller
Community Manager
0 Kudos

Siva_Venna
Contributor
In response to dmiller

‎03-26-2019 06:13 AM

Using mapper to drop fields is fine. I am asking is it possible to truncate the table before inserting data?. i.e table will have only latest execution data

0 Kudos

pedro_almeida
New Contributor
In response to Siva_Venna

‎03-26-2019 08:02 AM

As I see it, you have 2 options:

  1. Add an “Oracle Delete” Snap without any delete condition (DELETE FROM TableName) before inserting the data.
  2. 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.

Siva_Venna
Contributor
In response to pedro_almeida

‎04-12-2019 07:10 AM

Thanks pedro.almeida, it worked :+1:

0 Kudos