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 are the measure objects?

0 Answers  

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

How to configure mapping in informatica?

0 Answers  

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

What do think which one is the better joiner or look up?

0 Answers  

Whats there in global repository

0 Answers  

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

what are presession,postsession success and postsession failure commands ?

1 Answers  

In session log thier should not be a single error how will u do

3 Answers   HCL,

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

wf dont have integration severances how you can run?

0 Answers   TCS,