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
- 9905 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 |
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between router and filter transformation?
To provide support for Mainframes source data,which files r used as a COBOL files
What all join we can perform in LOOKUP transformation?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
What is main use of mapplet?
What is a difference between complete, stop and abort?
What is native users?
What is mapplet and a reusable transformation?
In which circumstances that informatica server creates Reject files?
Teradata 
