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

how to load duplicate row in a target

4 Answers  

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

what is the size of your data warehousing?

0 Answers   IBM,

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

explain about unit testing? in real time?

0 Answers   L&T,

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

Define enterprise data warehousing?

0 Answers  

What did you do in source pre load stored procedure

1 Answers  

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

what is left outer join?

3 Answers   L&T,

For more Informatica Interview Questions Click Here
Categories