Sukanya Das

 Profile Answers by Sukanya Das Questions by Sukanya Das

• Jun 4th, 2011

Late arriving Fact table:For example there was a credit card of transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2007. During this period there is a possibility of change...

Are Ramakrishna Rao

• Aug 14th, 2007

Late arriving Fact table:??????? This is rarely happens in practice. For example there was a credit card of HDFC transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2...

Answer Question  Select Best Answer

rpreddy

 Profile Answers by rpreddy Questions by rpreddy

• Mar 24th, 2008

A sheduling tool is a tool which is used to shedule the datawarehouse jobs...All the jobs which does some process are sheduled using this tool, which eliminates the manual intervension.

Pavan

• Aug 29th, 2005

The basic purpose of the scheduling tool in a DW Application is to stream line the flow of data from Source To Target at specific time or based on some condition.

Answer Question  Select Best Answer

ibrarx

 Profile Answers by ibrarx Questions by ibrarx

• Mar 7th, 2009

The smallest unit of analysis is called as 'grain'. Also known as the atomic unit of analysis. Deciding the grain and then on basis of it, the aggregation level is called as the granularity of a fact table.

Santanu Patra

• Jun 29th, 2005

It also means that we can have (for example) data agregated for a year for a given product as well as the data can be drilled down to Monthly, weekl and daily basis...teh lowest level is known as the grain. going down to details is Granularity

Answer Question  Select Best Answer

divya29july

 Profile Answers by divya29july Questions by divya29july

• Feb 11th, 2010

Dimension table contain the textual descriptors of the business. In a well designed dimemsion model, dimension table has many columns or attributes. Fields that are discretely valued description that ...

Kenny

• Jul 19th, 2005

Find where data for this dimension are located.  Figure out how to extract this data.  Determine how to maintain changes to this dimension (see more on this in the next section).  Change fact table and DW population routines.

Answer Question  Select Best Answer

idanh79

 Profile Answers by idanh79 Questions by idanh79

• Dec 7th, 2009

1. project planning2. business requirement definition3. dimension modeling+ technical architecture design4. pysical design+ product selection5. data staging design and development+end-user application development6. deployment+QAIdan Halfon

sulee

• Aug 22nd, 2007

  STRAGEGY & PROJECT PLANNINGDefinition of scope, goals, objectives & purpose, and expectationsEstablishment of implementation strategyPreliminary identification of project resourcesAssem...

Answer Question  Select Best Answer

mri_sonam

 Profile Answers by mri_sonam Questions by mri_sonam

• Dec 17th, 2008

The ability to move between different combinations of dimensions when viewing data with an OLAP browser/Report Browser.Multidimensional analysis tools organize the data in two primary ways: in multipl...

ucontactmadhu

• May 2nd, 2007

Hi, Slicing and Dicing is a feature that helps us in seeing the more detailed information about a particular thing. For eg: You have a report which shows the quarterly based performa...

Answer Question  Select Best Answer

khalidmehmoodawan

• Jul 25th, 2017

These are different BI tools from different companies but doing the same task.

vempati

 Profile Answers by vempati Questions by vempati

• Mar 14th, 2007

BO is a ROLAP Tool,Cognos is a MLAP Tool and MicroStrategy is a HLAP Tool

Answer Question  Select Best Answer

senthil kumar B

• Feb 13th, 2006

Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno

Balaji

• Jan 6th, 2006

in simple terms, the column in a fact table that does not map to any dimensions, neither it s a measure column.for e.g Invoice_no, Invoice_line_no in fact table will be a degenerate dimension (columns), provided if you dont have a dimension called invoice.

Answer Question  Select Best Answer

Sivakumar.R

 Profile Answers by Sivakumar.R Questions by Sivakumar.R

• Dec 7th, 2007

Bus Schema : Let we consider/explain these in x,y axis                       Dimension Table :&...

KPIZME

 Profile Answers by KPIZME Questions by KPIZME

• May 23rd, 2006

A BUS Schema or a BUS Matrix? A BUS Matrix (in Kimball approach) is to idetify common Dimensions across Business Processies; ie: a way of identifying Conforming Dimensions.

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 11th, 2008

Business rule is nothging the transformation requirement which will convert the raw data into business users required presentation so that business users can query and do the analysis on the Data.

abcde

 Profile Answers by abcde Questions by abcde

• Jun 27th, 2008

Business Rulw is nothing but a transformation needs to be applied on the dataacoording to the user requirement. e.g. in trading system notional value willbe multiplication of(fund price* shares)

Answer Question  Select Best Answer

Bill Inmon vs Ralph Kimball In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's camp. We describe below the difference between the two.Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their...

tisha24

 Profile Answers by tisha24 Questions by tisha24

• Mar 3rd, 2009

Bill inmon's approach:--------------------------- Approach is "TOP DOWN approach".  ;means Emphasize the data warehouse.   Starts with designing an enterprise model f...

sithu

 Profile Answers by sithu Questions by sithu

• Nov 19th, 2007

Bill inmon : Data warehouse à Data martRalph Kimbol : Data mart à Data warehouseCheers,Sithu, sithusithu@Hotmail.com

Answer Question  Select Best Answer

Which one of the following is used for high speed power application? a) BJT b) MOSFET c) IGBT d) TRIAC

sankar_cde

 Profile Answers by sankar_cde Questions by sankar_cde

• Nov 25th, 2010

Mosfet

revathy.perumalsamy

 Profile Answers by revathy.perumalsamy Questions by revathy.perumalsamy

• Aug 13th, 2010

b) MOSFET

Answer Question  Select Best Answer

Sreedhar Lokaray

• Nov 3rd, 2011

Business key is a primary key in the operational system. Surrogate key is a system generated primary key. In Dimensions and Facts we use Surrogate keys as Primary keys. Please refer my answer for the...

Ravi Teja N

• Sep 16th, 2011

Business Key is nothing but a natural key.Surrogate key is a system generator just like sequence in oracle.Basically we come across this in slowly changing dimensions type-II category.

Answer Question  Select Best Answer

Sreedhar Lokaray

• Nov 22nd, 2011

Could you please detail the question? Loading history is nothing to do with number of workflows. Might be you got confused between initial load and incremental load. A single workflow can be used for...

Ashwini Shetty

• Sep 18th, 2011

One work flow.....

Answer Question  Select Best Answer

I have a table with two columns name namely current,history but I dont have time stamp to make sure that when the data is updated or deleted.

Now How can I verify the latest data from above table?

kamesh

• Jan 30th, 2018

Based on the surrogate key we have identified the data Because surrogate keys is unique identifer for each row in a table

fazal

• Oct 29th, 2013

Select max (ora_scan) from table;

Select scn_to_timestamp (the_above_output) from dual;

Answer Question  Select Best Answer

Try to answer if you know

Anil

• Jul 25th, 2014

DWH helps you store the data while BI controls data for decision making, forcasting

Shrikanth

• Jun 12th, 2014

Data warehousing is a method to store the data in specially designed database. where as business intelligence processes the data in data warehouse to make some business decision.

Answer Question  Select Best Answer

Answered by Kiran on 2005-05-06 20:12:19: The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Very Large Database (VLDB)it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows. Typically, these are decision support systems or transaction processing applications serving large numbers of users. Cheers,Sithu

Muhammed Kamal

• Aug 30th, 2005

VLDB stands for Very Large Data Base, any database too large (normally more than 1TB) cosidered as VLDB.

Answer Question  Select Best Answer

the ODS is technically designed to be used as the feeder for the DW and other DM's -- yes.  It is to be the source of truth.Read the complete thread at http://asktom.oracle.com/pls/ask/f?p=4950:8:16165205144590546310::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:30801968442845,  

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 14th, 2007

Hi According to Bill Inmon's paradigm an enterprize can have one datware house and datamarts source their information from the datawarehouse. In the dataware house, information is stroed in 3rd No...

Aruna

• Dec 22nd, 2006

Data Mart is a sub section of Data Warehouse. e.g there is a datawarehouse of a company.Supose there is a datamart for all its departments. The complete company stores large historical data.In this case datamart of a deparment also stores historical data. can ODS be used here?

Answer Question  Select Best Answer

bobby

• May 31st, 2006

hi venkateshdimension , measure, detail are objects type.data types are character, date and numeric

ravi

• Jan 13th, 2006

The different data types in business objects are:1. Character.2. Date.3. Long text.4. Number

Answer Question  Select Best Answer

chandrarekha

• May 7th, 2007

Hierarchy is an ordered series of related dimension objects grouped together to perform the multidimensional analysis.Multidimensional analysis is? a technique to modify the data,so that the data? can be viewed from? different perspectives and at different levels

Satish

• Oct 6th, 2006

A related group of dimentions grouped together to perform multi dimentional analysis is known as Hierarchy.

Answer Question  Select Best Answer