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
- 7154 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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In informatics server which files are created during the session rums?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the status code in stored procedure transformation?
Please let me know how to make encryption and decryption with example?
hi real timers . iam waiting for ur reply regarding ETL TESTING
To import the flat file definition into the designer where should the flat file be placed?
Where is metadata stored?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is powercenter on grid?
What is a joiner transformation and why it is an active one?
Performance tuning in UNIX for informatica mappings?
How do you load only null records into target? Explain through mapping flow.
Write the different tools in the workflow manager?
