saivenkatesh

 Profile Answers by saivenkatesh Questions by saivenkatesh

• Jun 22nd, 2006

RalfKimball: he follows bottum-up approach i.e., first create individual Data Marts from the existing sources and then create Data Warehouse.BillImmon: he follows top-down approach i.e....

Mayee

• Jun 8th, 2006

Actually, the main difference is Kimball: fallows Dimentional ModellingInmon: fallows ER ModellingbyeMayee

Answer Question  Select Best Answer

mri_sonam

 Profile Answers by mri_sonam Questions by mri_sonam

• Dec 18th, 2008

Generally, data mining (sometimes called data or knowledge discovery) is the process of analyzing data from different perspectives and summarizing it into useful information - information that can be ...

hussenshaik

 Profile Answers by hussenshaik Questions by hussenshaik

• Sep 12th, 2008

Datamining is a process of looking information in different prospective that means, if you have data of sales of different products in different months we can find hiding data from same tables in the ...

Answer Question  Select Best Answer

nilanjan@wipro

• Aug 22nd, 2007

Architecture 1:Source=>Staging=>DWHArchitecture 2:Source=>Staging=>Datamarts                  &nbs...

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

UR RIGHT BINDU u hav nice concept ,,bye nagthumati_nagaraju@yahoo.co.in

Answer Question  Select Best Answer

Are Ramakrishna Rao

• Aug 14th, 2007

Hybrid SCDs are combination of both SCD?2 and SCD 3.Whatever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT.? There is new column added to provide the previous record info (generally it will be?surrogate key)

Pradeep Menon

• Aug 8th, 2006

Hybrid SCDs are combination of both SCD 1 and SCD 2.It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in ...

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 Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table.

ravi kumar guturi

• Mar 9th, 2006

Before broken into coloumns is going to the factAfter broken going to dimensions

sudhir

• Aug 4th, 2005

To add on, Foreign key elements along with Business Measures, such as Sales in $ amt, Date may be a business measure in some case, units (qty sold) may be a business measure, are stored in the fact table. It also depends on the granularity at which the data is stored

Answer Question  Select Best Answer