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
- 7206 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to open an older version of an object in the workspace?
How can you validate all mappings in the repository simultaneously?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is informatica? Why do we need it?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
define galaxy repository in informatica
Can you access a repository created in previous version of Informatica?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
According to his methodology what all you need before you build a datawarehouse
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
Teradata 
