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

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

how i will stop my workflow after 10 errors

1 Answers   HP,

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

What is batch and describe about types of batches?

2 Answers  

---

List the transformation in informatica.

1 Answers   TCS,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---