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
What are the tasks that source qualifier perform?
How can we use batches?
Differentiate between source qualifier and filter transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the mapping parameters and mapping variables?
How to generate sequence numbers?
What are different types of transformations available in informatica?
What is the use of code page?
How can you validate all mappings in the repository simultaneously?
Why union transformation is an active transformation?
Explain about cumulative Sum or moving sum?
What is a filter transformation?
Target increases every day even though no new record was inserted
Differentiate between sessions and batches?
What is main use of mapplet?