Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

how to delete duplicate records by using filter transfermation?

3 Answers  

---

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

how to remove staging area

1 Answers  

---