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
- 10317 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
How many ways a relational source definition can be updated and what are they?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is meant by lookup transformation?
Why filter transformation is an active one?
Enlist the tasks for which source qualifier transformation is used.
How to create the source and target database connections in server manager?
what is unit testing?tell me proceedure
Explain the use of aggregator cache file?
what is the difference between informatica6.1 and infomatica7.1
How you know when to use a static cache and dynamic cache in lookup transformation?
Define mapplet?
difference between repository database and repository service?
What is native users?
What are the types of schemas we have in data warehouse.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
