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
- 8 Answers
- 11105 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / sehajshangari1235
TAKE A NORMALIZER TRANSFORMATION.
CREATE A NORMALIZED PORT NAMED "DETAIL" WITH OCCURENCE 4
.CONNECT INPUT PORTS FROM SOURCE QUALIFIER TO EACH DETAIL
PORT IN NORMALIZER.
NEXT TAKE AN EXPRESSION TRANSFORMATION.IN THAT CREATE AN
OUTPUT PORT NAMED MONTH.AN IN EXPRESSION EDITER WRITE THE
LOGIC AS
DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE(
GCID_DETAIL,3,'MARCH','APRIL')))
CONNECT THIS OUTPUT PORT TO TARGET TABLE PORT!!!
SEHAJ
7204719446
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What's the layout of parameter file (what does a parameter file contain?)?
Did u used latest transformations of 8.6.0? for what?
What is a transaction control transformation?
What is domain in terms of informatica?
Clarify the utilization of aggregator cache record?
What are the different clients of powercenter?
what are 3 tech challenges/ common issues you face?
What are the issues you have faced in your project? How did you overcome those issues?
What is dimensional table?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to extract sap data using informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
What do you mean by blocking transformation?
How many input parameters can exist in an unconnected lookup?
How many ways are there to do 'remove duplicate records in informatica'?
