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
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
where to store informatica rejected data?
To import the flat file definition into the designer where should the flat file be placed?
What are data-driven sessions?
what is the difference between informatica6.1 and infomatica7.1
What is aggregator transformation in informatica?
What is the use of target designer?
What is the use of code page?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we create two repositories on same database instance in oracle?
Is it possible to revert a global repository to local one and why?
Under which circumstances, informatica server creates reject files?
In development project what is the process to follow for an etl developer from day1
What is a repository? And how to add it in an informatica client?
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?