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
- 9221 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 lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain direct and indirect flat file loading (source file type) - informatica
What is xml source qualifier transformation in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the sql query overwrite in source qualifier in informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can we override a native sql query within informatica? Where do we do it?
how many types of dimensions are available in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is sq transformation?
What are the different lookup cache(s)?
What is dynamic cache?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How do you change a non-reusable transformation to reusable transformation?
