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
- 7071 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / babu
SRC->SQ->SRT->AGT->TGT
SRT - SORT BY ID.
AGT-GROUP BY ID.
EXP - ID
NAME
*** ( V--> FOR VARIABLE PORT ,O-->FOR OUTPUT PORT)
V_NAME=IIF(V_ID=ID,V_NAME||','||NAME,NAME)
V_ID=ID
O_ID=V_ID
O_NAME=V_NAME
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
What are the popular informatica products?
What do you mean by filter transformation?
How many transformations can be used in mapplets.
What is a code page?
can u give example for factless fact table
What is meant by incremental aggregation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is joiner change?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you update the records with or without using update strategy?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Enlist few areas or real-time situations where informatica is required.
How does the aggregator transformation handle null values?
What is a repository manager?
