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
- 7335 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
What is a mapplet/worklet in informatica?
Briefly explain the aggregator transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How can we update a record in the target table without using update strategy?
What if the source is a flat-file?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is workflow monitor?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What do you understand by term role-playing dimension?
Differences between version 7.x and 8.x.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the difference between router and filter?
Define enterprise data warehousing?
what is diff b/t sorter t/r and agg have the option sorter property...
