Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7764 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
What is the function of look up transformation?
what is the size of u r source(like file or table)?
How can you validate all mappings in the repository simultaneously?
Briefly define a session task?
Why sorter is an active transformation?
What is exclusive and normal mode for repository services?
differences between service based and product based?
What is rank index in rank transformation?
How can you increase the performance in joiner transformation?
Performance tuning( what you did in performance tuning)
how we can load rejected record's at run time?(not through bad files)
which one is better performance wise joiner or look up
What does update strategy mean, and what are the different option of it?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a mapplet/worklet in informatica?
