1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / chandumba2005

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

What is substr in informatica?

0 Answers  

Without using any transformations how u can load the data into target?

15 Answers   IBM,

Describe expression transformation?

0 Answers  

What is domain and gateway node?

0 Answers  

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  




What is Datadriven?

2 Answers   Informatica,

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

Explain the code page compatibility?

0 Answers  

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

What is mapplet and a reusable transformation?

2 Answers  

what is curr val use for in sequence generator?

2 Answers   Emphasis,

For more Informatica Interview Questions Click Here
Categories