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?

Answer Posted / sri47

It Actually depends on the nature of the Column on which
you are goint to create an index.

Bit Map: If the column is of type Flag means contains 1 or
0.
Binary: If the column cintains numerical values.

Partitions also can be created if column values contains
only some list of values .

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between Target-based loading and constraint-based loading?

1042


How to partition the Session?

1154


What are the differences between source qualifier and joiner transformation?

1137


design of staging area?

2076


explain one complex mapping with logic? sales project?

6738


What is event and what are the tasks related to it?

1203


What are the different types of repositories created using informatica?

1171


what are 3 tech challenges/ common issues you face?

2397


How does the aggregator transformation handle null values?

1197


what is the Default Source Option For Update Strategy Transformation?

1287


What is the need for an etl tool?

1103


What is data movement mode in Informatica and difference between them?

1185


What is meant by active and passive transformation?

1194


What is Session and Batches?

1155


What is standalone command task?

1376