my source having the records like

ram 3
sam 5
tom 8

and i want to load into target like ram record 3 times,sam
record 5 times, tom record 8 times

Answer Posted / venkatesh.malneni

let us take the metadata as name and records ok,
in expression t/r we create a new o/p port in that write the
expression as name ||''||record||''||records||''|| times


connect the newly created o/p port to the target.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load the data from people soft hrm to people soft erm using informatica?

560


difference between repository database and repository service?

618


What is workflow monitor?

593


How to improve the performance of a session using sorter transformation?

686


What could be the possible resons of locks by user?

659






What is rank transformation?

577


How do you use reject loader.

2069


Define sessions in informatica etl?

615


what are the Methods For Creating Reusable Transformations?

647


What are the different ways to implement parallel processing in informatica?

860


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1206


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1771


How many number of sessions can one group in batches?

688


How many types of sessions are there in informatica.please explain them?

678


how to create user defined function (udf) in informatica

783