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

hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you

Question Posted / sivanizam8

Answers were Sorted based on User's Feedback



hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,ja..

Answer / saida

i think this data pivoting thats y v use normaliser T/R

Is This Answer Correct ?    2 Yes 0 No

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,ja..

Answer / sujana

use agg->grp by..
and then create 13o/p ports..and give condition for jan sal (iif month=jan,sal)..give appropriate conditions for remainng o/pports also...

crct me if m wrong

Is This Answer Correct ?    2 Yes 0 No

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,ja..

Answer / veeru

Use DECODE FUNCTION you can get answer.

Is This Answer Correct ?    2 Yes 0 No

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,ja..

Answer / anoymous

I think this reverse Data pivoting,
may be Normalizer T/r will use to achieve to target am not
sure..

Is This Answer Correct ?    1 Yes 1 No

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,ja..

Answer / mukesh

make 13 columns and add expression transformation and as
out and put the conditions like MAX(if(month='jan',sal)),
same for other months. very simple...

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

How will the document be delivered to me?

0 Answers  

What is difference macros and prompts?

2 Answers  

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

What is a mapplet/worklet in informatica?

0 Answers  

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

what is the flat file partition and where have to specify it

1 Answers   TCS,

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

For more Informatica Interview Questions Click Here
Categories