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
How to load the data from people soft hrm to people soft erm using informatica?
difference between repository database and repository service?
What is workflow monitor?
How to improve the performance of a session using sorter transformation?
What could be the possible resons of locks by user?
What is rank transformation?
How do you use reject loader.
Define sessions in informatica etl?
what are the Methods For Creating Reusable Transformations?
What are the different ways to implement parallel processing in informatica?
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.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many number of sessions can one group in batches?
How many types of sessions are there in informatica.please explain them?
how to create user defined function (udf) in informatica