Interested to Buy Any Domain ? << Click Here >> for more details...
If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
- 3 Answers
- 13798 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is a transaction control transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How many ways are there to do 'remove duplicate records in informatica'?
Please let me know how to make encryption and decryption with example?
Enlist the various types of transformations.
What are mapplets? How is it different from a Reusable Transformation?
In informatics server which files are created during the session rums?
How to load the data from a flat file into the target where the source flat file name changes daily?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is dynamic cache?
without table how to come first record only in oracle?
How to Create a folder using pmrep command?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
