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


Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Answers were Sorted based on User's Feedback



Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / sehajshangari1235

TAKE A NORMALIZER TRANSFORMATION.
CREATE A NORMALIZED PORT NAMED "DETAIL" WITH OCCURENCE 4
.CONNECT INPUT PORTS FROM SOURCE QUALIFIER TO EACH DETAIL
PORT IN NORMALIZER.

NEXT TAKE AN EXPRESSION TRANSFORMATION.IN THAT CREATE AN
OUTPUT PORT NAMED MONTH.AN IN EXPRESSION EDITER WRITE THE
LOGIC AS

DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE(
GCID_DETAIL,3,'MARCH','APRIL')))
CONNECT THIS OUTPUT PORT TO TARGET TABLE PORT!!!




SEHAJ
7204719446

Is This Answer Correct ?    3 Yes 1 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / sham

we can't sum aggregate function in Exp T/F.i.e it is not
possible to use sum() in expression T/F. so go through Agg T/F
....

Group by month
o/p port-------> sum(sal)

Is This Answer Correct ?    3 Yes 2 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / reddy

Answer:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

Step 1:

Source --> Source qualifier --> Normalizer --> Expr -->

Expression Condition:

DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE
(
GCID_DETAIL,3,'MARCH','APRIL')))


JAN 100
JAN 500
JAN 900
FEB 200
FEB 600
FEB 100
MAR 300
MAR 700
MAR 200
APR 400
APR 800
ApR 300

Step 2:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

1) Group by month
2) Sum(Amount)

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Is This Answer Correct ?    1 Yes 0 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / prabhu

Source qualifier --> Normalizer --> Expr --> Agg --> target

In Normalizer give the four numeric values as input and then take numeric value and it's GK_value to expression.

In Expression i have made flag for month and hardcoding values of month

Flag_Jan --> IN(GK_Salary,1,5,9,0)
Flag_Feb --> in(GK_Salary,2,6,10,0)
Flag_Mar --> in(GK_Salary,3,7,11,0)
Month --> iif(Flag_Jan = 1,'Jan',iif(Flag_Feb = 1,'Feb',iif(Flag_Mar = 1,'Mar','Aprl')))

In agg group by on month and get sun(numeric value)

Pass month and sum(numeric) value to target

Is This Answer Correct ?    1 Yes 1 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / dilip ingole

using query

SELECT 'JAN' AS MONTHS,SUM(JAN) FROM CALADERQUERY
UNION
SELECT 'FEB' AS MONTHS,SUM(FEB) FROM CALADERQUERY
UNION
SELECT 'MAR' AS MONTHS,SUM(MAR) FROM CALADERQUERY
UNION
SELECT 'APR' AS MONTHS,SUM(APR) FROM CALADERQUERY;

Is This Answer Correct ?    0 Yes 0 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / siva

Please Explain me briefly. Thank You.

Is This Answer Correct ?    1 Yes 2 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / chandra mouli

You will take Expression Transfermation.
In Expression Editon you can write lke this
sum(months) and group by month.

Is This Answer Correct ?    2 Yes 5 No

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 50..

Answer / chandu621

you will take Expression transfermation
and write expression like this

sum(months)

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Informatica Interview Questions

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


COM components can be used in Informatica

0 Answers  


what is distinct

4 Answers  


how to load duplicate row in a target

4 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


What are the tasks that source qualifier performs?

1 Answers  


How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


what is upstream and downstream transformation?

7 Answers  


How can you recover the session in sequential batches?

1 Answers  


Categories