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
- 5 Answers
- 9126 Views
- Patni, I also Faced
- E-Mail Answers
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 does refresh system mean, and what are its distinctive choice?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the surrogate key?
tell me about your project functionality
What is a node in Informatica?
What are active transformations.
write a query to retrieve the latest records from the table sorted by version(scd)
What is data movement mode in Informatica and difference between them?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
which one is better performance wise joiner or look up
How many input parameters can exist in an unconnected lookup?
What are active and passive transformations?
Which is the t/r that builts only single cache memory?
