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 / saida

i think this data pivoting thats y v use normaliser T/R

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you manage the Parameter files while migrating your data from one environment to another environment?

536


What do you mean by filter transformation?

547


What is decode in static cache?

586


Differences between connected and unconnected lookup?

603


how tokens will generate?

1727






Differentiate between a database and data warehouse?

650


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

687


Where can we find the throughput option in informatica?

598


What is informatica? Why do we need it?

628


What is dimensional table? Explain the different dimensions.

645


What does “tail –f” command do and what is its use as an Informatica admin.

625


What if the source is a flat-file?

584


What will be the approach?

575


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

599


my source is junk data how will u remove that junk data by using unix please any one replay me

3235