Latest Answer : Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle ...
Latest Answer : The datawarehousing where all the operations activities maintained, so that you can access the anaysed data from adifferent place.For example, take bank operations ... if A deposit 10,000/- in B account in Hyderabad  and B withdraw the money ...
Latest Answer : Because bitmapped indexes map values in the column to bits and store only the bit values, storage is reduced by several orders when bitmapped indexes are used. ...
How to find the no. of records in flat file. How to find the colums are changed or not. Ex: out of 100 columns 30 colums are changed. (using the DataStage)
How MS SS Reporting service will connect with SSAS OLAP Cube? How many dimensions will the SSAS Cube can handle? What about the performance trade off when increasing the volume of the data. Is it handle 1.5 million records of a single dimensions?
What difference between dimension and hierarchy>What is mean by maxl?difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?
Latest Answer : A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc. and the hierarchy is depend on the data source, like "hour glassmodel"Account dimentiontime period dimentionHigh dense dimentionlow dense ...