Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9305 Views
- TCS, I also Faced
- E-Mail Answers
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 informatica worklet?
How identifying bottlenecks in various components of informatica and resolving them?
Name the different lookup cache(s)?
What are the new features of informatica 9.x in developer level?
What is sq transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is a sorter transformation?
How to extract sap data using informatica?
What is meant by incremental aggregation?
explan ur project architecture?
What are the differences between joiner transformation and source qualifier transformation?
Explain why we use partitioning the session in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How will the document be delivered to me?
What is the difference between writing a joiner query in ANSI style and THETA style?
