Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following table
amount year quarter
1000 2003 first
2000 2003 second
3000 2003 third
4000 2003 fourth
5000 2004 first
6000 2004 second
7000 2004 third
8000 2004 fourth
i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 1000 2000 3000 4000
2004 5000 6000 7000 8000
can anybady help me to achieve the aboue result by using informatica.
thanks in advance.
- 5 Answers
- 7788 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari
select * from (select year,
max(amount,quarter='first') q1_amount,
max(amount,quarter='second') q3_amount,
max(amount,quarter='third') q4_amount,
max(amount,quarter='fourth') q4_amount
from table_name group by year );
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can you please explain me pre session and post session options?
how many types of dimensions are available in informatica?
What do you mean by channel change?
How can informatica be used for an organization?
Performance tuning( what you did in performance tuning)
COM components can be used in Informatica
What is session task and command task?
Is stop and abort are same 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,
How can we handle two sessions in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What are the measure objects?
How can we update a record in the target table without using update strategy?
What do mean by local and global repository?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
