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


Please Help Members By Posting Answers For Below Questions

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

705


Please let me know how to make Data masking in informatica..

1255


what is index?how it can work in informatica

1571


Explain the etl program with few examples.

537


Name at least 5 different types of transformations used in mapping design and state the use of each.?

660






How to extract the informatica rejected data?

739


Design a mapping to load the cumulative sum of salaries of employees into target table?

886


explain one complex mapping with logic? sales project?

6131


What is a sequence generator transformation?

563


What is a predefined event?

648


Performance tuning in UNIX for informatica mappings?

2126


In which transformation you cannot drag ports into it?

773


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

1521


What could be the possible resons of locks by user?

655


How can you define user defied event?

609