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 should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?
- 4 Answers
- 10152 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / mithilesh kumar rai
First Use Expression and then Use Aggregater
After Expression U will receive
1 a
1 a b
1 a b c
2 a
2 a b
2 a b c
then use aggregater group by key 'ID'
After Aggregater u will receive
1 abc
2 abc
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
How many transformations can be used in mapplets.
Define the various join types of joiner transformation?
Name the different lookup cache(s)?
What are the advantages of using informatica as an etl tool over teradata?
What is rank transformation in informatica
What is dynamic cache?
What is exclusive and normal mode for repository services?
what is degenerated dimension?
What are the tuning techniques you applied during your last project
What are the types of caches in lookup? Explain them.
Why union transformation is an active transformation?
Explain the difference between a data warehouse and a data mart?
update strategy transformation in informatica
What is aggregate cache in aggregator transformation?
