write a query row to column follwing source?
quarter sales
q1 5000
q1 9000
q1 7000
q1 6000
q2 5000
q2 4000
q2 3000
q2 1000
q3 4000
q3 3000
q3 1000
q3 2000
q4 5000
q4 400
i want the output?
q1 q2 q3 q4
sales
- 3 Answers
- 6710 Views
- Cognizant, Flextronics, I also Faced
- E-Mail Answers
Answer Posted / gm
SQL:
select quarter, sales from table_name
group by quarter, sales;
Informatica:
Source-SQ-Exp-Normalizer Trans.-Tgt
In Normalizer Transformation we can do row into column.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
what is the -ve test case in your project.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do you mean by filter transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How would you copy the content of one repository to another repository?
what is song in infrmatica...?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Reusable transformation and shortcut differences
how to create user defined function (udf) in informatica
What are the different types of olap? Give an example?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the meaning of up gradation of repository?
4 yrs etl devloper roles and responsibilities?any body give solutions
When do you use sql override in a lookup transformation?
