Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following table
quarter sales
q1 1000
q1 2000
q1 3000
q1 4000
q2 5000
q2 6000
q2 7000
q2 8000
q3 1000
q3 2000
q3 3000
q3 4000
q4 5000
q4 6000
q4 7000
q4 8000
i want the output format like
q1 q2 q3 q4
1000 5000 1000 5000
2000 6000 2000 6000
3000 7000 3000 7000
4000 8000 4000 8000
- 5 Answers
- 10141 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / parthu
It may possible with Normalizer transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a rank transform?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Enlist the differences between database and data warehouse.
How to generate sequence numbers using expression transformation?
What are the static cache and dynamic cache in informatica?
Sequence generator, when you move from develoment to production how will you reset
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How big was your fact table
design of staging area?
What are the advantages of using informatica as an etl tool over teradata?
What is lookup transformation?
what are the deliverables?in your project?
What are the tuning techniques you applied during your last project
Explain about cumulative Sum or moving sum?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
