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
- 6358 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
Is there any target staging area in informatica not staging area
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the different transaction levels available in transaction control transformation?
scenario where i can use only concurrent execution of workflow.
what is $$$$?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the difference between source qualifier transformations source filter to filter transformation?
What is depict expression change?
What are the components of Informatica? And what is the purpose of each?
What is the maplet?
What is deployment group?
What are the databases that informatica can connect to windows?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
how to load dimension table and fact table. plz tell me the steps.
what is song in infrmatica...?
