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 is joiner transformation in informatica?
How do you load alternate records into different tables through mapping flow?
Why filter transformation is an active one?
Explain dynamic target flat file name generation in informatica
Please let me know how to make Data masking in informatica..
What are the reusable transformations?
What are mapplets?
How do you take back up of repository?
During the running session, output files are created by informatica server. Enlist few of them.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is powercenter on grid?
What is the Process to creating lookup transformation in informatica
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 ?
What is joiner change?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?