write a query row to column follwing source?
quarter sales
q1 5000
q1 9000
q1 7000
q1 6000
q2 5000
q2 4000
q2 3000
q2 1000
q3 4000
q3 3000
q3 1000
q3 2000
q4 5000
q4 400
i want the output?
q1 q2 q3 q4
sales
Answers were Sorted based on User's Feedback
Answer / ankit kansal
Hi All,
select sales,sum(q1),sum(q2),sum(q3),sum(q4)
from
select 'sales' as sales
,case when quarter='q1' then sales else 0 end case as q1
...q2
...q3
...q4
)temp group by sales;
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
It wouldn't work many to one concept for Normalizer.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / gm
SQL:
select quarter, sales from table_name
group by quarter, sales;
Informatica:
Source-SQ-Exp-Normalizer Trans.-Tgt
In Normalizer Transformation we can do row into column.
| Is This Answer Correct ? | 4 Yes | 7 No |
in a table it has 200 rows the query is select 150 from tablename.whats the output
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
update strategy transformation in informatica
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what is upstream and downstream transformation?
Why union transformation is an active transformation?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
why u go for dimensions ?
What is souce qualifier transformation it is active or passive
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
what is the difference between lookupoveride and joiner?