I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE
Answer Posted / guest
Aggregator with group by on column with values 1, 2, 3
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
what is song in infrmatica...?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Differentiate between source qualifier and filter transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What do you mean by blocking transformation?
What is the meaning of decode in informatica?
How we can create indexes after completing the load process?
What is a filter transformation and why it is an active one?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can we handle two sessions in informatica?
What is a grid in Informatica?
What is enterprise data warehousing?
How to do unit testing in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Target increases every day even though no new record was inserted