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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the size of your data warehousing?
Explain about Informatica server process that how it works relates to mapping variables?
In warehouses how many schemas are there?
Could you explain what is enterprise data warehouse?
What are the advantages of using informatica as an etl tool over teradata?
What is decode in informatica?
Differentiate between joiner and lookup transformation?
What is source qualifier transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain sessions?
How do you handle two sessions in Informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the use of aggregator cache file?