write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.
I hope i have given right solution.
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / ankit kansal
Hi All,
As Question says Write a sequel query..
select sum(1),sum(2) from (
select case when region=1 then salary else 0 end as 1,
case when region=2 then salary else 0 end as 2
from table_name )test;
http://deepinopensource.blogspot.com/
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santosh kumar sarangi
Its not possible to create a table with number as column name.
Is This Answer Correct ? | 0 Yes | 0 No |
SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lakshman
HEY VIKRAM why do you post
answer when you dont know answer.
NORMALIZED T/R CAN CONVERT COLUMNS DATA TO ROWS DATA
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravi
select * from table_name pivot(sum(sales) for region in(1,2));
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lchenchureddy
use Normalized transformation in the mapping.we get result.
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / vikram
Hey are you guys not informatica resource.. why do you post
answer when you dont know answer.
I have seen this question on many pages and ans give as
Normalizer.
Guys: Correct answer is to use Aggregator..
Normalize : converts rows to column
Agg : Can convert columns to row
Is This Answer Correct ? | 3 Yes | 5 No |
What are mapplets?
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
How we can create indexes after completing the load process?
Plz..let me know differences between Informatica 7.1 and 8.1?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the Differences between connected and unconnected lookup?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is hash partition?
What differs when we choose the sorted input for aggregator transformation?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in