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
Answer / raj
sourcequalifier....>normalizer.....>expression...>aggrgater....>target
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / usha
by using normalizer transformation we can convert rows to
columns.
s-->SQ--->NRM-->Target
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dev
hi Raj, plz explain, what we need to do in expression
transformation...
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Separate from a database, an information bazaar, and an information stockroom?
What is meant by LDAP users?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
How union transformation is active ?
What is difference between partioning of relatonal target and partitioning of file targets?
what is mystery dimension?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
How to recover sessions in concurrent batches?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is powercenter on grid?
How will you update the row without using update statergy?