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
- 8621 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
Can you generate sequence numbers without using the sequence generator transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is a snowflake schema?
What is the function of union transformation?
What is an Integration service in Informatica?
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,
Enlist few areas or real-time situations where informatica is required.
What is a surrogate key?
What is incremental aggregation?
Is it possible to create multiple domains on a single Informatica server?
How to load the data from people soft hrm to people soft erm using informatica?
What is the use of source qualifier?
how to create user defined function (udf) in informatica
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?
