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
- 10 Answers
- 17628 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
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 the different lookup cache(s)?
lookup transformation with screenshots
How do you load unique records into one target table and duplicate records into a different target table?
How to improve the performance of a session using sorter transformation?
Slowly changing dimensions, types and where will you use them
Is there any way to read the ms excel datas directly into informatica?
What is a code page?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the types of lookup transformation?
what is the -ve test case in your project.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the components of Informatica? And what is the purpose of each?
What is the need of etl tools?
What is session task and command task?
Which development components of informatica have the highest usage?
