Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 2 Answers
- 10499 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ande
we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ghouse
to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the method of error handling when session is running?
How to eliminate 1st and last rows from the source and load the inbetween rows.
How will you combine 3 different sources with a single source?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is degenerated dimention table?
what is metadata?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
what is confirmed dimension?
How can we integrate different flat file data in a single mapping and with in a single execution
Different sorts of metadata that stores in the storage facility?
Teradata 
