hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
Answer Posted / shyam
by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
What are junk dimensions?
What do you mean by worklet?
In informatica workflow manager, how many repositories can be created?
What is update strategy transform?
Why union transformation is an active transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How are indexes created after completing the load process?
What is the use of transformation?
tell me the rules and responsblites in our project(my project is development)
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the different versions of informatica?
Define filter transformation?
What is Session and Batches?
What do think which one is the better joiner or look up?