Answer / narender.vankuri

There are four Types of Session Partitioning Are there
1)Pass Through(Default)
2)Key Range
3)Round Robin
4)Hash Partition

List few etl bugs?

0 Answers  

---

Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,

---

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  

---

how do u set partition points in the mapping?

0 Answers  

---

how many maximum session supports to multiload in teradata ??

0 Answers   IBM,

---

---

Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,

---

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

---

what is the difference between date cache and lindex cache?

1 Answers  

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---

What is staging area referring to?

0 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  

---

In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  

---