One source row to be inserted in mult...

One source row to be inserted in multple rows

Posted in the Informatica Forum

Kiran B

New Westminster, Canada

#1 Mar 11, 2011

I am using Informatica. I would like to insert one row from source to two rows in target. I need to know how to transform this data in Informatica.

Any response is appreciated


#2 Mar 14, 2011
if we can map single row 2 times,can it works i think..
jagadeeswararedd y

Pune, India

#3 Apr 25, 2011
take target table 2 instances then source conn to two target table instances

United States

#4 Apr 28, 2011
Hi sweatha

Toronto, Canada

#5 Jun 22, 2011
Try at "TALK 2 EXPERTS" for an immediate response.



Parsippany, NJ

#6 Dec 12, 2011
You can Normalizer Transformation to read one row which convert to multiple rows.

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Loading a specific Erwin model version into Met... Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records Feb '16 beginer_informatica 1
First and last rec from flat file to table Feb '16 Nan 1
active and passive t/f Feb '16 Nan 1
Informatica PowerCenter SAML Support Feb '16 Steve 1
More from around the web