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
Explain how to import oracle sequence into informatica?
What is the sql query overwrite in source qualifier in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
Differences between version 7.x and 8.x.
What is target load order?
What are pre and post-session shell commands?
How to create the source and target database connections in server manager?
What differs when we choose the sorted input for aggregator transformation?
What is a joiner transformation and why it is an active one?
How are the sources and targets definitions imported in informatica designer?
What is informatica etl tool?
What do you mean by filter transformation?
How can repository reports be accessed without sql or other transformations?
Scheduling properties,whats the default (sequential)
what are the Methods For Creating Reusable Transformations?