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 / sai.masarapu.chowdary
using normalizer transformation we can do as follows:
from source qualifier give the column to the normalizer tr
then put occur for 4 times.
put that occurs to the target. thats it..
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How you can differentiate between connected lookup and unconnected lookup?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How does a sorter cache works?
Please let me know how to make encryption and decryption with example?
What is rank index in rank transformation?
What are the components of Informatica? And what is the purpose of each?
What is the use of an aggregator cache file?
Make a note of the quantity vaults made in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
design of staging area?
what is the Default Source Option For Update Strategy Transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.