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 are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the function of aggregator transformation?
Explain transaction control transformation in informatica
Reusable transformation and shortcut differences
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Why sorter is an active transformation?
Target increases every day even though no new record was inserted
can we override a native sql query within informatica? How do we do it?
What are the different transaction levels available in transaction control transformation?
What is the maplet?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a passive transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
explain one complex mapping with logic? sales project?
What is meant by pre and post session shell command?