How to delete the data in the target table after loaded.
Answer Posted / 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 |
Post New Answer View All Answers
What is union transformation in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the difference between a repository server and a powerhouse?
Which is the t/r that builts only single cache memory?
Where do we use mapping variables in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the tuning techniques you applied during your last project
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the components of Informatica? And what is the purpose of each?
What is the difference between stop and abort in informatica
What is Session and Batches?
How to load a Dimension ? and how to load a fact table?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the need of etl tools?