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 / sai.masarapu.chowdary
using normalizer transformation we can do as follows:
from source qualifier give the column to the normalizer tr
then put occur for 4 times.
put that occurs to the target. thats it..
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
What is the advantage of informatica?
How does a rank transform differ from aggregator transform functions max and min?
What is the Process to creating lookup transformation in informatica
What is the function of union transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is a sequence generator transformation?
How do you promote a non-reusable transformation to reusable transformation?
What's the layout of parameter file (what does a parameter file contain?)?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain sql transformation in script mode examples in informatica
What is the use of an aggregator cache file?
How to elaborate powercenter integration service?
How can one identify whether mapping is correct or not without connecting session?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?