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.

What is the target load order?

3 Answers   HCL, Informatica,

Explain sessions?

0 Answers  

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

What are the new features of the server manager in the informatica 5.0?

1 Answers  

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

Is informatica power center designer has 64 bit support?

1 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

How to load data in informatica ?

0 Answers