Number of records in target based on ...

Number of records in target based on dept count

Posted in the Informatica Forum

Since: Mar 13

Chennai, India

#1 Mar 11, 2013
The source data is shown below:
Ename, Deptcount
Mark, 3
Henry 2
Chris 1
In the target table, i want the output according the dept count. I want to repeat Mark 3 times, Henry 2 times and Chris 1 time in the target. The data in the target should look as
Mark, 3
Mark, 3
Mark, 3
Henry 2
Henry 2
Chris 1
Create a mapping to solve this informatica problem.
With Regards

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
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
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) Mar '16 anil 1
Update Records (Feb '16) Feb '16 beginer_informatica 1
First and last rec from flat file to table (Feb '16) Feb '16 Nan 1
More from around the web