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
- 7649 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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Clarify the utilization of aggregator cache record?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How can one identify whether mapping is correct or not without connecting session?
What can we do to improve the performance of informatica aggregator transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can anyone explain me about retail domain project in informatica?
What is an aggregator transformation?
Performance tuning( what you did in performance tuning)
If informatica has its scheduler why using third party scheduler?
What is a repository? And how to add it in an informatica client?
Explain the pipeline partition with real time example?
What are junk dimensions?
What is workflow manager?
Can we create a node as a gateway node and the same node can be assigned to a grid?
