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
What are the new features of informatica 9.x in developer level?
What is transformation?
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
What is flashback table ? Advance thanks
What is aggregator transformation in informatica?
Can we create multiple integration service on single repository?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
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 ?
Explain incremental aggregation in informatica
What is the difference between a repository server and a powerhouse?
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?
What is dimensional table?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance