Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
Answer Posted / vinod kumar
copy the source for 3 times then total 4 sources will be
there in your mapping and move all sources to the target you
will get 4 times of same data in target
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
Explain the difference between mapping parameter and mapping variable?
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
tell me 5 session failure in real time how can you solve that in your project?
What are the differences between oltp and olap?
can u any challenge your project?
How to improve the performance of a session using sorter transformation?
What is the commit type if you have a transaction control transformation in the mapping?
When do you use sql override in a lookup transformation?
What is meant by incremental aggregation?
How we can create indexes after completing the loan process?
Write the unconnected lookup syntax?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is confirmed fact in dataware housing?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?