Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Which kind of index is preferred in DWH?

Answers were Sorted based on User's Feedback



Which kind of index is preferred in DWH?..

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

Which kind of index is preferred in DWH?..

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

Post New Answer

More Informatica Interview Questions

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


What are the basic needs to join two sources in a source qualifier?

4 Answers  


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


How many ways you create ports?

1 Answers  


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..!

3 Answers   TCS,


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?

2 Answers   Thomson Reuters,


Different circumstance which drives informatica server to expel records?

0 Answers  


if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,


explain abt joiner t/r?

1 Answers   IBM,


what is the size of ur database(like oracle)

2 Answers   HP,


HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,


How can you differentiate between powercenter and power map?

0 Answers  


Categories