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

Parameter and variable differences

2063


What are the components of Informatica? And what is the purpose of each?

1056


can you please explain me pre session and post session options?

7576


What is session task and command task?

1303


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1052


What are the limitations of joiner transformation?

1114


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2362


Can we create multiple integration service on single repository?

1191


What is the sql query overwrite in source qualifier in informatica

1094


r u done any partitions in ur project?

1827


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7396


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1277


What are the informatica performance improvement tips

1096


What is workflow? What are the components of the workflow manager?

1146


What will be the approach?

987