Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
- 8 Answers
- 10191 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Describe expression transformation?
How can we get multiple output values using an unconnected lookup transformation?
How to generate the HTML output using Informatica.
How to delete duplicate record in Informatica?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
How to load a relational source into file taget?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is casual dimension?
What are the mapping parameters and mapping variables?
Can we change Dynamic to Static or Persistent cache? If so what happens?
without matching columns in two tables. how can you join
What are the features of complex mapping?
Teradata 
