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
In development project what is the process to follow for an etl developer from day1
can anyone suggest best free Talend data integration training online
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the function of union transformation?
Explain sessions and how many types of sessions are there?
Explain the mapping variable usage example in informatica
Explain joiner transformation in informatica
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?
What is parallel processing in informatica?
Explain the use of aggregator cache file?
Explain load alternative records / rows into multiple targets - informatica
Informatica Checkpoints
Enterprise data warehouse your projects phase by phase explain?
Mention few power centre client applications with their basic purpose?
What is workflow monitor?