Answer / sneha latha.r

Bitmap index is used for repeating values.

ex: Gender:male/female
Account status:Active/Inactive

Btree index is used for unique values.

ex: empid.

Answer / amarnath

Bitmap index is used on low cardinality columns i.e less
distinct columns eg: Gender: Male/Female.

B-tree is used on high cardinality colums
eg: Student first name

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

What do you understand by SOA of Informatica?

0 Answers  

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

What is IQD file?

1 Answers  

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---