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...


i want to convert below src into target

src is as follows
maths 30
science 20
social 81

i want data in trg like below

maths science social
30 20 81

Answers were Sorted based on User's Feedback



i want to convert below src into target src is as follows maths 30 science 20 social ..

Answer / vikram

You need to use
SQ> Agg > TGT

>>> In AGG Ports>>>
Subject
Marks
O_maths = max(marks, subject='maths')
0_science = max (marks, subject ='science')
O_Social= max (marks,subject='social')

>>>>TGT
O_maths -> Maths
O_Scie -> Science
O_Social -> Social

Is This Answer Correct ?    7 Yes 0 No

i want to convert below src into target src is as follows maths 30 science 20 social ..

Answer / amedela chandra sekhar

Use Normalizer t/r, it convert column into rows,row into
columns.

Is This Answer Correct ?    2 Yes 11 No

Post New Answer

More Informatica Interview Questions

what is mean by flag 4 in update strategy t/r

6 Answers  


Explain the flow of data in Iinformatica?

1 Answers  


there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,


where to select code page option?

2 Answers   TCS,


How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,


Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,


What is sql query override? When did u use sql query override?

1 Answers   TCS,


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


what is Active lock explain

0 Answers   Satyam,


why we are using surogate key in real time give me explanation

2 Answers   TCS,


Categories