Answer / amedela chandra sekhar

BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.








I hope i have given right solution.

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/

Answer / santosh kumar sarangi

Its not possible to create a table with number as column name.

Answer / kamleshmishra291

SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));

Answer / lakshman

HEY VIKRAM why do you post
answer when you dont know answer.


NORMALIZED T/R CAN CONVERT COLUMNS DATA TO ROWS DATA

Answer / ravi

select * from table_name pivot(sum(sales) for region in(1,2));

Answer / lchenchureddy

use Normalized transformation in the mapping.we get result.

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

can we override a native sql query within informatica? Where do we do it?

0 Answers  

what are types of dimentions?

3 Answers  

What are the new features in Informatica 5.0?

1 Answers  

Did u used latest transformations of 8.6.0? for what?

0 Answers  

what is difference between COM & DCOM?

1 Answers   Satyam,

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

Differentiate between mapping parameter and mapping variable?

1 Answers  

How many number of sessions that u can create in a batch?

3 Answers  

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

tell me the push down optimization

2 Answers   Wipro,

What are the connected or unconnected transforamations?

2 Answers  

why we need informatica

2 Answers   HCL,