hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
Answer Posted / pooja
write sql query in tgt property .. per sql & post sql
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Please let me know how to make Data masking in informatica..
what is index?how it can work in informatica
Explain the etl program with few examples.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to extract the informatica rejected data?
Design a mapping to load the cumulative sum of salaries of employees into target table?
explain one complex mapping with logic? sales project?
What is a sequence generator transformation?
What is a predefined event?
Performance tuning in UNIX for informatica mappings?
In which transformation you cannot drag ports into it?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What could be the possible resons of locks by user?
How can you define user defied event?