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
Explain scd type 3 through mapping.
What are the informatica performance improvement tips
Can informatica load heterogeneous targets from heterogeneous sources?
What are the different ways to implement parallel processing in informatica?
Can we create a Integration service without a Repository service and vice versa?
What are the main issues while working with flat files as source and as targets ?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to extract the informatica rejected data?
How does a sorter cache works?
Briefly define a session task?
Make a note of the quantity vaults made in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
list out all the transformations which use cache?
How to configure mapping in informatica?
What is standalone command task?