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 persistent lookup cache?
Define filter transformation?
What is Session and Batches?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How you can differentiate between connected lookup and unconnected lookup?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Describe the impact of several join conditions and join order in a joiner transformation?
what is unit testing?tell me proceedure
State the limitations where we cannot use joiner in the mapping pipeline?
explan ur project architecture?
What are the restrictions of union transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the advantages of informatica?
What is target designer and target load order?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.