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
- 9771 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
Briefly explain the aggregator transformation?
What is option by which we can run all the sessions in a batch simultaneously?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Different circumstance which drives informatica server to expel records?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to load last n records of file into target table - informatica
How do you load unique records into one target table and duplicate records into a different target table?
Describe data concatenation?
Plz can any one say me how to get the informatica certification materials and dumps
What is fact table? Explain the different kinds of facts.
How an expression transformation differs from aggregator transformation?
What are the differences between oltp and olap?
Why sorter is an active transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
