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
- 9042 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
How do we call shell scripts from informatica?
explain abt ur project architecture?
What is option by which we can run all the sessions in a batch simultaneously?
What is union transformation?
Explain the difference between mapping parameter and mapping variable?
Is it possible to revert a global repository to local one and why?
Write the unconnected lookup syntax?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the types of presistent cache in look up tr.
How to extract the informatica rejected data?
Enterprise data warehouse your projects phase by phase explain?
Have you worked with/created Parameter file
Enlist some properties of sessions.
What are session parameters ? How do you set them?
How many types of sessions are there in informatica.please explain them?
