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
- 11393 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 |
Performance wise which is better joiner or look up ? Give me with example?
How do you load first and last records into target table?
How to retrieve last two days updated records?
Explain about Informatica server process that how it works relates to mapping variables?
tell me 5 session failure in real time how can you solve that in your project?
How union transformation is used?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What does update strategy mean, and what are the different option of it?
how do the project develops? pls specify right from the start to end in step by steps.
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Enlist few areas or real-time situations where informatica is required.
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
Teradata 
