Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

What is a sequence generator transformation?

0 Answers  

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

What are the transformations that are not supported in mapplet?

0 Answers  

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

What is dimensional table?

0 Answers  

Clarify the aggregator change?

0 Answers  

What are the different lookup cache(s)?

0 Answers  

For more Informatica Interview Questions Click Here
Categories