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
- 10022 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 is data modelling? what are types of modelling?In which suituation will use each one?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What is a joiner transformation and why it is an active one?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
what is song in infrmatica...?
plz plz plz send client names and project names in informatica?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What is a predefined event?
How to join three sources using joiner?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Quickly characterize reusable change?
Teradata 
