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 / anoymous
I think this reverse Data pivoting,
may be Normalizer T/r will use to achieve to target am not
sure..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is workflow manager?
Partition, what happens if the specified key range is shorter and longer
Clarify the utilization of aggregator cache record?
How can you differentiate between powercenter and power map?
How we can create indexes after completing the load process?
Under what condition selecting sorted input in aggregator may fail the session?
What are the new features of Power Center 5.0?
What are the different lookup cache(s)?
Briefly explain the aggregator transformation?
What is the difference between a repository server and a powerhouse?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How do you load unique records into one target table and duplicate records into a different target table?
Where is metadata stored?
Explain the features of connected and unconnected lookup.
what is the size of u r source(like file or table)?