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

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

Question Posted / natrajdreams

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 / raj

sourcequalifier....>normalizer.....>expression...>aggrgater....>target

Is This Answer Correct ?    8 Yes 1 No

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

Answer / usha

by using normalizer transformation we can convert rows to
columns.

s-->SQ--->NRM-->Target

Is This Answer Correct ?    2 Yes 0 No

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

Answer / dev

hi Raj, plz explain, what we need to do in expression
transformation...

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 / kamleshmishra291

SQ->EXP->NRM->TGT

EXP :-- CREATE 4 OUTPUT PORTS
PORT1= 'JAN'
PORT2='FEB'
PORT3='MAR'
PORT4='APRIL'
AGGR :-- DRAG ALL PORTS FROM EXP AND CREATE 4 OUTPUT PORT
PORT5= SUM(JAN)
PORT6=SUM(FEB)
PORT7=SUM(MAR)
PORT8=SUM(APRIL)
NRM : CREATE 2 PORTS
MONTHS- OCCUR(4)- STRING
TOTAL- OCCUR(4)- NUMBER
CONNECT NRM OUTPUT PORT TO TGT

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 / shankar

source qualifier > expression <for best practice> > aggregator > normalizer . target.

here in this the SQ will be for relational & flat files, then we use expression for best practice, in this we take the ports which we need into target also we can rename the ports for our convenience just to avoid confusion.

Then for calculating totals we use aggregator.

to convert the rows to col we use the normalizer. This is to my knowledge. Thank you if wrong pls post.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

what is diff between grep and find

3 Answers   IBM, iFlex,

What is Session and Batches?

0 Answers   Informatica,

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  




how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

what is target load plan

2 Answers   Cap Gemini,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories