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.

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

How to run a session, which contains mapplet?

1 Answers  

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

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  

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

what is the difference between onsite & client site?

1 Answers  

Different circumstance which drives informatica server to expel records?

0 Answers  

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

What is a grid in Informatica?

0 Answers  

how to duplicates from expression transformation without using sorter before that

1 Answers  

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,