What are snapshots?

0 Answers  

---

WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,

---

Explain the key challenges that you face while performing etl testing.

0 Answers  

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  

---

What are cubes and olap cubes?

0 Answers  

---

Eliminating of duplicate records without using dynamic lookups

3 Answers  

---

What exact we can see in table?

1 Answers  

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  

---

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

---

How many steps etl contains explain with example?

0 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  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---