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

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

How is Data Models Used in Practice?

1 Answers  

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

What is the need of etl tools?

0 Answers  

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

What is synonym?

2 Answers   Patni,

---