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
- 10039 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
Explain the features of connected and unconnected lookup.
How to use procedural logic inside infromatica?
Informatica settings are available in which file?
What is persistent lookup cache?
what is the difference between informatica6.1 and infomatica7.1
How to extract sap data using informatica?
Differentiate between source qualifier and filter transformation?
What are the different transaction levels available in transaction control transformation?
What is status code in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain informatica architecture - version 8 / 9
What is the function of look up transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is rank transformation in informatica
Which development components of informatica have the highest usage?
