suganyasks

 Profile Answers by suganyasks Questions by suganyasks

• Dec 19th, 2005

In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table...

suganya

• Dec 19th, 2005

In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table...

Answer Question  Select Best Answer

RaviKumar Reddy

• May 18th, 2006

 As part of Struts FrameWork we can decvelop the Action Servlet,ActionForm servlets(here ActionServlet means which class extends the Action class is called ActionServlet and ActionFome ...

Answer Question  Select Best Answer

Senthil Raj

• Aug 3rd, 2006

Aggregate table?contains summarised data. The materialized view are aggregated tables. for ex in sales we have only date transaction. if we want to create a report like sales by product per year. in ...

Answer Question  Select Best Answer

thumatinagaraju

• Nov 2nd, 2006

I think there is no other way than recreating the cube.

Answer Question  Select Best Answer

Bhanu

• Jan 25th, 2007

A data warehousing best practice is to create surrogate keys--typically a meaningless simple integer--for the primary key in each dimension table. The associated fact table rows use this same surrogate as a foreign key reference to the dimension tables.

Answer Question  Select Best Answer

anilreddy27

 Profile Answers by anilreddy27 Questions by anilreddy27

• Jan 29th, 2007

Multidimensional databases consolidate and calculate data to provide different views. With Multidimensional databases users can pivot the data to see the information from different view point. It cont...

Abhishek

• Aug 28th, 2006

What is Multidimensional database? How is it different from Relational database and how it works?

Answer Question  Select Best Answer

bneha15

 Profile Answers by bneha15 Questions by bneha15

• May 9th, 2007

In informatica we have an option of 'rebuild cache'. Use that to rebuild cache.

Answer Question  Select Best Answer

adam89parkar

• Jul 12th, 2007

Hi ,I-Bot is a object which we configure in Siebel web catalog for generating auto report to perticular person.See i will give example my manager want the report of perticular sales area that how sell...

Nisith

• Apr 3rd, 2007

IBot is an utility available in Siebel Analytics, which is used for reports scheduling as well as Alerts sent to the required recipients on different web accessible / communication devices.

Answer Question  Select Best Answer

harishsj

 Profile Answers by harishsj Questions by harishsj

• Jul 24th, 2007

Datawarehouse V/S OLAPBoth the terms are interchangble.DW:Data from different source systems is stored in a relational database for end use analysis.Data is organized in summarized, aggregated,subject...

Guest

• Jan 4th, 2007

Don't get confused ,OLAP and Datawarehouse are the terms that can be used interchangeably in some places.Online Analytical Processing is a concept whereas Datawarehouse is the collection of data in denormalized form so that it can help in fast and frequent analysis.

Answer Question  Select Best Answer

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

Yes.Because these OLAP systems involved in decision making system of the firm.the historical data which includes in olap systems helps to take business intelligence solutions.

smriti

• Jul 12th, 2007

Yes, OLAP databases are called decision support systems because it helps in analysing the historical and present data of the organisations and thereby helping in taking intelligent business decisions

Answer Question  Select Best Answer

sweeta.arya

 Profile Answers by sweeta.arya Questions by sweeta.arya

• Jan 17th, 2008

Snapshot is a fact table which describes about the state of things ina particular instance of time. It mainly involves semiadditive or nonadditive facts!

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

Snap shot is like a photo copy.It is nothing but a permanent local copy of the data which is included in your report.

Answer Question  Select Best Answer

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 12th, 2008

//Semi additive facts//Whenever possible the facts or measure in the fact table should be chosen as perfectly additive. However some measure of intensity is not perfectly additive across all of the di...

jgd.ramesh

• Aug 15th, 2007

E-R modelling is entity relation between two table.Dimension modelling is contain three table Aggregate, Fact table, Dimension table

Answer Question  Select Best Answer

siteshkumar

 Profile Answers by siteshkumar Questions by siteshkumar

• Jul 8th, 2008

Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table

ravi kumar guturi

• Mar 14th, 2006

Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

Answer Question  Select Best Answer

desaial

 Profile Answers by desaial Questions by desaial

• Dec 9th, 2008

Active Data Warehouse is the DWH that enables the decision makers of the organisation to understand the trends and patterns of the market (by analysing the captured transactional data in the DWH) and thereby helping them to arrive at an INFORMED future decision(s).Thanks.Alpesh

lab125

 Profile Answers by lab125 Questions by lab125

• Feb 19th, 2008

Active Data Warehousing (ADW)The technical ability to capture transactions when they change, and integrate them in to the warehouse - along with maintaining batch or scheduled cycle refreshes.

Answer Question  Select Best Answer

desaial

 Profile Answers by desaial Questions by desaial

• Dec 11th, 2008

Data Warehousing: It is a process that includes the extracting the data (from source systems), cleaning, transforming and delivering them to the Data Warehouse (databases) for the loading purpose.&nbs...

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 14th, 2007

Business Intelligence:BI is a broad cateogry of applications and technologies for gathering, integrating, storing, analysing and providing access to data to help enterprise users make better business ...

Answer Question  Select Best Answer

malay_dutta

 Profile Answers by malay_dutta Questions by malay_dutta

• Jan 27th, 2009

An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(howev...

ABHI2411

 Profile Answers by ABHI2411 Questions by ABHI2411

• Jan 2nd, 2009

A MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(howeve...

Answer Question  Select Best Answer

How do you manage the database triggers in DWH?

trayambakojha

 Profile Answers by trayambakojha Questions by trayambakojha

• Sep 3rd, 2009

Triggers are stored procedures that are invoked when certain conditions or events occur. The granularity and flexibility of the conditions and events that cause a trigger to fire are database spec...

Answer Question  Select Best Answer

idanh79

 Profile Answers by idanh79 Questions by idanh79

• Dec 2nd, 2009

 Hierarchy contains many levels, every level contain an attribute.Idan Halfon

thumatinagaraju

• Nov 2nd, 2006

Hi nice ans u given and i think we can add number of of levels under hirarchy

Answer Question  Select Best Answer

Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?

manojrana

 Profile Answers by manojrana Questions by manojrana

• Dec 23rd, 2009

Innmons approach is better to load data from Data Marts.

Mehul@DWH

 Profile Answers by Mehul@DWH Questions by Mehul@DWH

• Oct 9th, 2008

1. The direction of the data load depends on the approach that was adopted while designing the Warehouse and the datamart. If the top down approach, which Kimbal mentions is used, then data will ...

Answer Question  Select Best Answer

priyanka25feb

 Profile Answers by priyanka25feb Questions by priyanka25feb

• Jan 2nd, 2010

A data mart is a group of subjects that are organized in a way that allows them to assist departments in making specific decisions. For example, the advertising department will have its owndata mart, ...

sivakumar.p

• May 25th, 2007

Data Mart is subset of dataware house deal with single area of data and is organized by quick analysis.

Answer Question  Select Best Answer