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
- 9409 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / guest
Aggregator with group by on column with values 1, 2, 3
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
Write the advantages of partitioning a session?
Difference between Target-based loading and constraint-based loading?
What is a filter transformation?
Define update strategy?
What are the popular informatica products?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Target increases every day even though no new record was inserted
Clarify the aggregator change?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is joiner transformation in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
