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
- 10151 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / chandu
In Expression transfermation, if( sales = q1,sales,0)
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
Differentiate between a repository server and a powerhouse?
Define enterprise data warehousing?
How to extract sap data using informatica? What is abap? What are idocs?
What is powercenter on grid?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can anyone suggest best free Talend data integration training online
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Which files are created during the session rums by informatics server?
How identifying bottlenecks in various components of informatica and resolving them?
Explain the scenario which compels informatica server to reject files?
What is deployment group?
Differences between connected and unconnected lookup?
How to generate sequence numbers without using the sequence generator transformation?
pmscmd startworkflow -sv
