Interested to Buy Any Domain ? << Click Here >> for more details...
in source one table is there.
id value
--- ------
1 a
2 b
3 c
1 d
2 e
1 f
in target i want
id value
---- ------
1 a,d,f
2 b,e
3 f
How to implement it in informatica without using normalizer
transformation?
- 2 Answers
- 7066 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / siddu
SOURCE->SRT->EXP->TGT
SRT - Sort by column col1.
EXP - col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
r u done any partitions in ur project?
Target increases every day even though no new record was inserted
How to handle decimal places while importing a flatfile into informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is aggregate cache in aggregator transformation?
What is a passive transformation?
How to implement security measures using repository manager?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the reusable transformation?
Write the unconnected lookup syntax?
Why filter transformation is an active one?
Why do we need informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain what transformation and how many are there in informatica?
