How to delete the (flat file) data in the target table after
loaded.

Answers were Sorted based on User's Feedback



How to delete the (flat file) data in the target table after loaded...

Answer / vaishali bisht

whenever we load data in flat file it automatically override the old data.

Is This Answer Correct ?    0 Yes 0 No

How to delete the (flat file) data in the target table after loaded...

Answer / james

whatever data u want to delete from target table,simply go
with truncate option.

Is This Answer Correct ?    1 Yes 14 No

Post New Answer

More Informatica Interview Questions

Diff b/w ShortCut and reusabel Object ?

4 Answers  


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


How to improve the performance of Aggregate transformation?

3 Answers   Dmss,


How to extract sap data using informatica?

0 Answers  


Explain the etl program with few examples.

0 Answers  






How to elaborate powercenter integration service?

0 Answers  


What is a command that used to run a batch?

2 Answers  


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


What are the tasks that source qualifier perform?

0 Answers   Informatica,


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  


Categories