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 meant by active and passive transformation?
How to do the error handling of if ur source is flatfiles?
What is decode in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you update the records with or without using update strategy?
Is there any way to read the ms excel datas directly into informatica?
How would you join a node to the already existing domain?
Define the various join types of joiner transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is meant by lookup transformation?
How to load last n records of file into target table - informatica
What is a predefined event?
How does a sorter cache works?
How to extract the informatica rejected data?