thumatinagaraju

• Nov 2nd, 2006

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

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

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

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

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

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

Is time a semi-additive fact or a non-additive fact?Explain it with an example.

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Sep 7th, 2010

Time is a semi additive measure.  If you have a fact table containing information on the number of items in stock in a warehouse, then it would never make sense to aggregate these measures over t...

Answer Question  Select Best Answer

uga_boy

• Jan 20th, 2012

Surrogate keys are advisable for a few different reasons: 1. In a large enterprise environment with many data sources to pull from you will inevitably come across a data feed that either does not con...

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 10th, 2012

The shortcut keys are related to a specific window and will only work in that window. It is part of the name of a menu item or button, where it can be underlined, and is available (without modifiers) ...

elanchum

• Jul 18th, 2011

Hotkey: which is used to open r close an application.....
shortcutkey: used to perform actions with in the application....

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

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 10th, 2012

May be Applet.getImage(new URL(...)) can be used to convert java applet into image file.

munavar.shaik

 Profile Answers by munavar.shaik Questions by munavar.shaik

• Jan 18th, 2011

Java applets are not used in DWH. So its irrelevant question in DWH concepts group.

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

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

Sreedhar Lokaray

• Nov 3rd, 2011

Let me just give the Data quality problems. If I explain it will go page by page. 1. Dummy values in source system fields. 2. Absence of data in source system fields. 3. Multipurpose fields. 4. Crypt...

Faizal

• Aug 30th, 2011

You have to test all the transformations in your ETL and write negative scenarios.

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

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

satwant singh

• Nov 29th, 2011

Full Load is the entire data dump load taking place the very first time. Gradually to synchronize the target data with source data, there are further 2 techniques:- Refresh load - Where the existing...

Sreedhar Lokaray

• Nov 3rd, 2011

In simple words, after transforming the data it is loaded into the DWH. Two distinct groups of tasks form the data loading function. When you complete the design and construction of the DWH and go liv...

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