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
- 5 Answers
- 8433 Views
- Informatica, I also Faced
- E-Mail Answers
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 deliverables?in your project?
What is an expression transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the types of schemas we have in data warehouse.
How to load the data from people soft hrm to people soft erm using informatica?
What is aggregator transformation in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain the etl program with few examples.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What does reusable transformation mean?
Do you find any difficulty while working with flat files as source and target?
How does a sorter cache works?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to extract sap data using informatica? What is abap? What are idocs?
What are the uses of etl tools?
