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
Explain what are the different versions of informatica?
Can we create a Integration service without a Repository service and vice versa?
What are roles and groups and benefits of using them?
Difference between Target-based loading and constraint-based loading?
How to extract sap data using informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is olap (on-line analytical processing?
what are 3 tech challenges/ common issues you face?
How many ways are there to create ports?
where to store informatica rejected data? How to extract the informatica rejected data?
In informatics server which files are created during the session rums?
How do you load unique records into one target table and duplicate records into a different target table?
What are active and passive transformations?
While migrating the data from one environment to another environment how would you manage the connections?
what are the deliverables?in your project?