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
- 11319 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
Separate from a database, an information bazaar, and an information stockroom?
Mention a few design and development best practices for informatica?
expain about the tune parameters?
What is workflow? What are the components of workflow manager?
What is the benefit of partitioning a session?
How do you load unique records into one target table and duplicate records into a different target table?
What is depict expression change?
what is the Default Source Option For Update Strategy Transformation?
What is pmcmd command?
what is song in infrmatica...?
What are the different versions of informatica?
Do you find any difficulty while working with flat files as source and target?
What is a surrogate key?
permutations of mapplet
The question was on time stamp. what is the difference between HH and HH24 when to use when.
