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
- 9979 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 do you migrate data from one environment to another?
How we can create indexes after completing the loan process?
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the advantages of partitioning a session?
How might one distinguish in the case of mapping is right or not without associating session?
How to generate sequence numbers using expression transformation?
Write the different tools in the workflow manager?
What is the difference between Active and Passive transformation?
Is there any way to read the ms excel datas directly into informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the advantages of informatica?
What is the function of aggregator transformation?
Differentiate between source qualifier and filter transformation?
