in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d

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?

Question Posted / ranjan

2 Answers
7152 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in targe..

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

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in targe..

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

Post New Answer

More Informatica Interview Questions

Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata

1 Answers Cognizant,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers Polaris, Zensar,

What is a difference between complete, stop and abort?

0 Answers

How do you recover rows from a failed session

1 Answers

What do you understand by a term domain?

0 Answers

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers TCS,

What is Code Page Compatibility?

1 Answers

can anyone explain me about sales project in informatica?