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.

How can we store previous session logs?

0 Answers  

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

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

1 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

What are different types of transformations available in informatica?

0 Answers  

---

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

What is status code?

2 Answers  

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

connected and unconnected lookups?

4 Answers  

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---