Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7361 Views
- Satyam, I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? Where do we do it? How do we do it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the surrogate key?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we handle two sessions in informatica?
Is it possible to use a client with different version than that of its Informatica server?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to configure mapping in informatica?
How to go to the older version for a mapping?
Explain the difference between mapping parameter and mapping variable?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to use procedural logic inside infromatica?
Under what condition selecting sorted input in aggregator may fail the session?
What is a dimensional model?
