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 are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---

How is Data Models Used in Practice?

1 Answers  

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

How can we use batches?

0 Answers  

---

What is a snowflake schema?

0 Answers  

---