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
- 9991 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
server hot-ws270 is connect to Repository B. What does it mean?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is degenerated dimension?
Why union transformation is an active transformation?
Why sorter is an active transformation?
What is powercenter on grid?
What do think which one is the better joiner or look up?
How can you define user defied event?
What is native users?
Explain the informatica workflow?
How do you promote a non-reusable transformation to reusable transformation?
Differences between version 7.x and 8.x.
Why update strategy and union transformations are active?
How to handle decimal places while importing a flatfile into informatica?
What is primary and backup node?
