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
- 7955 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
on my previous answer i had given a solution using SQL query now i will give you using informatica.
1) Take Expression and create three four output ports.
(i) q1 o IIF(quater='first',amount,0)
--same for q2,q3,q4
2)In Next step use a AGG Trans.
(i) Again create four ports with group by on Year column
q1_amount sum(q1)
q2_amount sum(q2) ..
--same for q3 and q4
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
How can you increase the performance in joiner transformation?
What are the modules in Power Center
How to create the source and target database connections in server manager?
What do you mean incremental aggregation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain about cumulative Sum or moving sum?
How does the aggregator transformation handle null values?
What are the limitations of joiner transformation?
Enlist the various types of transformations.
What is a filter transformation?
What is the difference between a connected look up and unconnected lookup?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the code page compatibility?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
