Answer / srinivas

dataflow

FF-----> Sourcequalifier...>aggregatore T/F....>target

in aggregator transformation add three new ports
o_col1,0_col2,o_col2 and make output ports
and expression in out ports
o_col1-----MAX(col1),
o_col2-----Max(col2),
o_col3-----Max(col3);
and connect these output ports to target
you will get the resul

Answer / sushma

FF ---> SOURCE QUALIFIER ---> EXPRESSION ---> AGGREGATOR ---
>TARGET FILE

In Expression TRFM,
a) for each column, create an expr to replace null values
with 0.
IIF(ISNULL(port_name),0,port_name)
b) create an output port (dummy_col) and set its value to 1

In Aggregator TRFM
a) Group by the dummy_col
b) for each of the 4 columsn, find the max value

Answer / suri

thats a oracle answer
but in informatica u have to use reverse pivoiting

Answer / maheshkumar bvn

first convert flat file to oracle table

create table num_test(field1 int,field2 int,field3
int,field4 int);

insert into num_test values(1000,null,null,null);
insert into num_test values(null,2000,null,null);
insert into num_test values(null,null,3000,null);
insert into num_test values(null,null,null,4000);



select max(field1),max(field2),max(field3),max(field4) from
num_test;

result:
1000 2000 3000 4000

Answer / jayesh

Filter in source qualifire itself..in sq query or sq filter.

Define pmcmd command?

0 Answers  

What is the Rankindex in Ranktransformation?

7 Answers  

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

which transformation uses cache?

3 Answers   Keane India Ltd,

difference between stop and abort

2 Answers  

What is the difference between router and filter?

0 Answers  

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers