Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10161 Views
- Patni, I also Faced
- E-Mail Answers
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
How to do unit testing in informatica? How to load data in informatica ?
What is incremental aggregation?
What are the components of Informatica? And what is the purpose of each?
What is the difference between informatics 7x and 8x and what is latest version?
scenario where i can use only concurrent execution of workflow.
What is the meaning of up gradation of repository?
How does the aggregator transformation handle null values?
How to use procedural logic inside infromatica?
Enlist the tasks for which source qualifier transformation is used.
how to create user defined function (udf) in informatica
Which version configuration tool used in ur project?
What are the issues you have faced in your project? How did you overcome those issues?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is workflow manager?
