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

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

What are the methods for creating reusable transforamtions?

2 Answers  

What is an Integration service in Informatica?

0 Answers  

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

what is unique constraint error ?

2 Answers   TCS,

Why do we need informatica?

0 Answers  

where to select code page option?

2 Answers   TCS,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

explain about session partitions ?

1 Answers