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 |
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How do you remove duplicate records in informatica? And how many ways are there to do it?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
Can we insert and update a target table without using update strategy transformation?How?
How to load duplicate records in to a target table which has a primary key?
what is fact table?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
What is the difference between informatica 7.0 and 8.0?
What will be the approach?
Performance wise which is better joiner or look up ? Give me with example?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach