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?
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
Performance tuning in UNIX for informatica mappings?
How to create or import flat file definition in to the warehouse designer?
How you prepared reports for OLAP?
have u done any performance tuning? how u ll do?
what is the complex transformation you used in informatica
What is the use of an aggregator cache file?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the types of presistent cache in look up tr.
what is mean by complex business rule ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Why is sorter an active transformation?
without table how to come first record only in oracle?
Please let me know how to make Data masking in informatica..
Explain the code page compatibility?