Answer / deepthi

1.Use sorted data and enable option 'sorted i/p'
2.By using incremental aggregation
3.group by simple columns like numeric columns
4.use filter transformation before aggregator to avoid
unnecessary aggregation on unwanted columns.

Answer / ritu

By giving sorted inputs and do not forget to tick the
sorted input box

Answer / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

What is synonym?

2 Answers   Patni,

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

Explain the informatica workflow?

0 Answers  

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---