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
- 5 Answers
- 9141 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
How can one identify whether mapping is correct or not without connecting session?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the differences between joiner transformation and source qualifier transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What does role playing dimension mean?
Is there any target staging area in informatica not staging area
Define mapplet?
What is joiner transformation?
Explain the types of lookup transformation?
can u give example for factless fact table
Explain the types of transformations?
can u any challenge your project?
Enlist few areas or real-time situations where informatica is required.
Explain the different lookup methods used in informatica?
