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


Please Help Members By Posting Answers For Below Questions

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1674


where to store informatica rejected data?

862


To import the flat file definition into the designer where should the flat file be placed?

854


What are data-driven sessions?

961


what is the difference between informatica6.1 and infomatica7.1

1934


What is aggregator transformation in informatica?

750


What is the use of target designer?

809


What is the use of code page?

797


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

892


Can we create two repositories on same database instance in oracle?

857


Is it possible to revert a global repository to local one and why?

877


Under which circumstances, informatica server creates reject files?

843


In development project what is the process to follow for an etl developer from day1

1492


What is a repository? And how to add it in an informatica client?

915


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9400