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

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

Scheduling properties,whats the default (sequential)

0 Answers  

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

How mapping parameter and variable works

1 Answers  

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

How do you recover rows from a failed session

1 Answers  

Please let me know how to make Data masking in informatica..

0 Answers  

permutations of mapplet

0 Answers   TCS,

what is fact table?

9 Answers  

How to jion 2 tables, without using any condition?

11 Answers   Amazon,