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

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


How to implement security measures using repository manager?

0 Answers  


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


Could any one to tell Fact table Partitioning?

2 Answers  


What are the performance considerations when working with aggregator transformation?

0 Answers  


In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,


what type of transformation is not supported by mapplets?

4 Answers   CTS,


Whats the difference between $, $$, $$$

9 Answers  


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


explain different levels in pushdown optimization with example?

2 Answers   TCS,


Categories