Which kind of index is preferred in DWH?
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 |
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is dynamic cache?
What is the term PIPELINE in informatica ?
What is the capacity of power cube?
have you developed documents in your project? and what documents we develop in realtime?
What is the meaning of decode in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
How to get EVEN & ODD numbers separately?
Without using any transformations how u can load the data into target?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
How can we use batches?