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
- 7153 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
Mention few advantages of router transformation over filter transformation.
What is meant by incremental aggregation?
Define filter transformation?
Mention a few design and development best practices for informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What if the source is a flat-file?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can u generate reports in Informatica?
What is a mapplet/worklet in informatica?
What is resilience time?
What is the need of an ETL tool?
Is there any way to read the ms excel datas directly into informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you load unique records into one target table and duplicate records into a different target table?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
