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
- 6275 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
Where can we find the throughput option in informatica?
What is exclusive and normal mode for repository services?
Define mapping and session?
What can we do to improve the performance of informatica aggregator transformation?
What happens when a session fails and you click on recover?
what is the hint? how to use it to reduce the query processing in program?
Explain joiner transformation in informatica
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
list out all the transformations which use cache?
What is the cumulative sum and moving sum?
What is a difference between complete, stop and abort?
What are data-driven sessions?
How to call shell scripts from informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is flashback table ? Advance thanks
