Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 2 Answers
- 10548 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 |
Explain the mapping variable usage example in informatica
Explain sessions and how many types of sessions are there?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What is joiner cache?
How to join three sources using joiner?
why we are using level option in normalizer transformation
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
What are the circumstances that infromatica server results an unreciverable session?
What is InformaticaPowerCenter?
Using Expression transformation how to remove duplicate records from a relational source?
What is sq transformation?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Teradata 
