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
- 9137 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
What is DR strategy for Informatica project?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the need for an etl tool?
Enlist the tasks for which source qualifier transformation is used.
Sequence generator, when you move from develoment to production how will you reset
Did u used latest transformations of 8.6.0? for what?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How an expression transformation differs from aggregator transformation?
Write the program through which the records can be updated?
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?
What is the cumulative sum and moving sum?
What are junk dimensions?
To import the flat file definition into the designer where should the flat file be placed?
What are batches?
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?
