Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8991 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / nitin
Create two mapping pipelines
One pipeline is to
1) Break the record 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B using normalizer transformation
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
Then pass the records into a flat file target.
Source-->SQ-->Normaliser--> Target (Output_file1)
Output_file1-->SQ--> Aggregator-->Target(Output_file2)
Create another mapping pipeline where the above records act as the source and the delimiter as '|'.
Use an aggregator transformation to group based on the first column and use the SUM(col2) GROUP BY col1.
write the output to the target file with | as delimiter
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do mean by local and global repository?
What is complex mapping?
Do you find any difficulty while working with flat files as source and target?
What is the Process to creating lookup transformation in informatica
How are the sources and targets definitions imported in informatica designer?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differentiate between Load Manager and DTM?
How you can differentiate between connected lookup and unconnected lookup?
What are the main features of Oracle 8i with context to datawarehouse?
In which transformation you cannot drag ports into it?
Explain the features of connected and unconnected lookup.
How to join three sources using joiner? Explain though mapping flow.
What is blocking transformation?
Explain the pipeline partition with real time example?
What is the difference between informatics 7x and 8x and what is latest version?
