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 schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

Differentiate between a database and data warehouse?

1 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

explain about unit testing? in real time?

1 Answers   L&T,

---

Where is metadata stored?

1 Answers  

---

What is target designer and target load order?

1 Answers  

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

can anyone suggest best free Talend data integration training online

1 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2 Answers   IBM,

---

What is workflow manager?

1 Answers  

---

What is meant by query override?

1 Answers  

---