Answer / kishore

b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.

Answer / ranvir thakor

WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.

Answer / sarvesh

bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.

What is meant by active and passive transformation?

0 Answers  

---

What is the function of look up transformation?

0 Answers  

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

what is the difference between onsite & client site?

1 Answers  

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

What are the different clients of powercenter?

0 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

Can we make worklet inside worklet?

1 Answers  

---