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
- 9965 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 |
what are testing in a mapping level please give brif eplanation
Why we select the table which has minimum number of records as Master table in joiner?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
what is galaxy repository?
what is scd?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
What is degenerated dimention table?
What is polling in informatica ?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How to run a session, which contains mapplet?
Teradata 
