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

What are the new features of informatica 9.x in developer level?

793


What is transformation?

888


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1746


What is flashback table ? Advance thanks

1708


What is aggregator transformation in informatica?

754


Can we create multiple integration service on single repository?

968


Explain pushdown optimization $pushdownconfig parameter - informatica

934


What is the difference between STOP and ABORT options in Workflow Monitor?

964


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1964


Explain incremental aggregation in informatica

883


What is the difference between a repository server and a powerhouse?

1178


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1038


What is dimensional table?

824


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1869


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1768