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
- 8350 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
By using aggregator t/r we can achieve.
use || function
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is informatica powercenter repository?
What is joiner change?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Why union transformation is an active transformation?
How many number of sessions can one group in batches?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Mention few advantages of router transformation over filter transformation.
Can we create a Integration service without a Repository service and vice versa?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is native users?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Describe the impact of several join conditions and join order in a joiner transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to partition the Session?
