How to delete the data in the target table after loaded.

Answers were Sorted based on User's Feedback



How to delete the data in the target table after loaded...

Answer / venky

write post sql in target table as truncate table tablename

Is This Answer Correct ?    5 Yes 0 No

How to delete the data in the target table after loaded...

Answer / honey

SQ---> Properties tab-->Post SQL
delete from target_tablename

SQL statments(s) executed using the source database
connection, after a pipeline is run

Is This Answer Correct ?    6 Yes 2 No

How to delete the data in the target table after loaded...

Answer / davankumar p

we have the property in session truncate option.

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More Informatica Interview Questions

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,


How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,


What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  


surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,


can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  


follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


What is the use of an aggregator cache file?

0 Answers  


Explain the use of aggregator cache file?

0 Answers  


If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  


Categories