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

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

How do you implement scheduling in Informatica?

1 Answers  

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

What are pre and post-session shell commands?

0 Answers  

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

All active transformations r passive or not?

7 Answers  

why we use informatica in our project?

2 Answers   TCS,

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

Which files are created during the session rums by informatics server?

0 Answers  

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,