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 / paramaguru
source qualifier---field1
connect field1 to all the 4 field in the normalizer.
normalizer: In the normalizer maker occurs as 4
it will creat automatically
NEWfield1
NEWfield2
NEWfield3
NEWfield4
NEWFIELD
GK_NEWFIELD
GCID_NEWFIELD
target:OUTPUT
connect newfield to the target output
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the mapping parameters and mapping variables?
How do you load unique records into one target table and duplicate records into a different target table?
Design time, run time. If you don't create parameter what will happen
Explain what are the different versions of informatica?
How do you load alternate records into different tables through mapping flow?
Which transformation should we use to normalise the COBOL and relational sources?
What is the difference between a repository server and a powerhouse?
How you can differentiate between connected lookup and unconnected lookup?
How can we remove the duplicates from flat file source?
What is a node in Informatica?
Differentiate between sessions and batches?
What are the new features of informatica 9.x at the developer level?
How many ways are there to do 'remove duplicate records in informatica'?
During the running session, output files are created by informatica server. Enlist few of them.
How many types of sessions are there in informatica.please explain them?