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
Answer Posted / mukesh
make 13 columns and add expression transformation and as
out and put the conditions like MAX(if(month='jan',sal)),
same for other months. very simple...
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Performance tuning( what you did in performance tuning)
Please let me know how to make encryption and decryption with example?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How big was your fact table
What are the main features of Oracle 8i with context to datawarehouse?
How can we remove the duplicates from flat file source?
How can one identify whether mapping is correct or not without connecting session?
What is the Rank index port in Rank transformation?
What is a grid in Informatica?
What can we do to improve the performance of informatica aggregator transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is mapping debugger?