Use DECODE FUNCTION you can get answer.

hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you

Question Posted / veeru

5 Answers
9986 Views
Patni, I also Faced
E-Mail Answers

Answer Posted / veeru

Use DECODE FUNCTION you can get answer.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

generate date / time dimension in informatica

1125

what is unit testing?tell me proceedure

2221

What is fact table? Explain the different kinds of facts.

1076

Tell me about MD5 functions in informatica

929

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2122

What is meant by query override?

1059

How to update a particular record in target with out running whole workflow?

1576

what is degenerated dimension?

3996

What is Data Caches size?

1091

How many dimensions are there in informatica?

1086

Explain lookup transformation is active in informatica

1104

write a query to retrieve the latest records from the table sorted by version(scd)

1068

Explain how to import oracle sequence into informatica?

1011

What is the way to execute pl/sql script using informatica mapping?

1603

Briefly explain the aggregator transformation?

1008