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
- 5 Answers
- 11249 Views
- HP, I also Faced
- E-Mail Answers
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 |
how to remove staging area
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
what is the monster dimension plz give me one example
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is informatica etl tool?
how many session run unix environment what command using ?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
What is a look up function? What is default transformation for the look up function?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
Teradata 
