Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 2 Answers
- 10434 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 |
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the basic needs to join two sources in a source qualifier?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How many ways you create ports?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
Different circumstance which drives informatica server to expel records?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
explain abt joiner t/r?
what is the size of ur database(like oracle)
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
How can you differentiate between powercenter and power map?
Teradata 
