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
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
When do you use sql override in a lookup transformation?
What is a pre-defined event and user-defined event?
How to generate sequence numbers without using the sequence generator transformation?
What are the guidelines to be followed while using union transformation?
What is informatica powercenter repository?
What are the tasks that can be performed using sq?
Can you generate sequence numbers without using the sequence generator transformation?
How are indexes created after completing the load process?
Differentiate between sessions and batches?
What is the benefit of session partitioning?
What are the tasks that source qualifier perform?
which one is better performance wise joiner or look up
Which transformation is needed while using the Cobol sources as source definitions?
What is the need of etl tools?