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
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 aggregate cache in aggregator transformation?
What's the layout of parameter file (what does a parameter file contain?)?
In how many ways we can create ports?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is an unconnected transformation?
What is meant by lookup transformation?
can anyone suggest best free Talend data integration training online
Explain lookup transformation source types in informatica
Design time, run time. If you don't create parameter what will happen
How to load last n records of file into target table - informatica
What can we do to improve the performance of informatica aggregator transformation?
Separate from an archive server and a powerhouse?
Explain the features of connected and unconnected lookup.
What are the new features of informatica 9.x at the developer level?