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
Hi,
The source data is shown below:
Code:
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
Code:
Mark, 3
Mark, 3
Mark, 3
Henry 2
Henry 2
Chris 1
Create a mapping to solve this informatica problem.
With Regards
anu

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