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
- 9398 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 are the modules in Power Center
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What if the source is a flat-file?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the difference between source qualifier transformations source filter to filter transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you convert single row from source into three rows into target?
Suppose we do not group by on any ports of the aggregator what will be the output?
Write the different tools in the workflow manager?
What are the databases that informatica can connect to windows?
What is olap (on-line analytical processing?
What is Index Caches size?
Explain joiner transformation in informatica
