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 is dynamic cache?
What is target designer and target load order?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How to load last n records of file into target table - informatica
What is the difference between a connected look up and unconnected lookup?
What are connected or unconnected transformations?
What does update strategy mean, and what are the different option of it?
what is index?how it can work in informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the restrictions of union transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What is a difference between complete, stop and abort?
Separate from an archive server and a powerhouse?
Repository user profiles
Which transformation should we use to normalise the COBOL and relational sources?