when should one create lookup transformation ?

2 Answers  

---

What are the names of the layers in etl?

0 Answers  

---

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

---

Explain the use lookup tables and Aggregate tables?

0 Answers  

---

Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  

---

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  

---

Eliminating of duplicate records without using dynamic lookups

1 Answers  

---

What are dimensions?

0 Answers  

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,

---

Explain what is etl process? How many steps etl contains explain with example?

0 Answers  

---

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---