what are homegeneous sorces and heterogeneous data sources ? Is flat file different from those two

Sreedhar Lokaray

• Nov 3rd, 2011

The dictionary meaning of Homogeneous is Uniform and Heterogeneous is Mixed. For example if a mapping is using only Oracle sources or Flat files or DB2 or XML or any other then they are called Homogen...

Answer Question  Select Best Answer

what is high level document(HLD),lowlevel document(LLD),MAPPING documents ? what is the stuff they contains?

Sarat

• Nov 13th, 2014

High Level Design document will prepare by the Data Modeling people to generate the required data warehouse schema for the ETL purpose. LLD : Low Level Design is the design document which will be use...

Answer Question  Select Best Answer

surrogate key is nothing but a primary key , but Does have any business meaning

avinash

• Apr 16th, 2016

Surrogate key is a key that is generated by a system and its has unique values.

Answer Question  Select Best Answer

What relationship is resolved by an intersecting or associative entity ?
a) Recursive
b) Mandatory one to one
c) Many to Many
d) One to One

Nagireddy

• Sep 27th, 2019

Recursive

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

Kenneth

• Jul 18th, 2005

An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying that the DW is subjected to.

Nirav

• May 15th, 2005

Data Warehouse is a part of OLAP (On-Line Analytical Processing). It is the source from which any BI tools fetch data for Analytical, reporting or data mining purposes. It generally contains the data...

Answer Question  Select Best Answer

kalpit

 Profile Answers by kalpit Questions by kalpit

• Mar 10th, 2009

Data validation is generally done manually in DWH, in this case if source and TGT are relational you need to create SQL scripts to validate source and target data, and if source is Flat file or non re...

uma

• May 3rd, 2006

Data validation is to make sure that the loaded data is accurate and meets the business requriments.Strategies are different methods followed to meet the validation requriments

Answer Question  Select Best Answer

Sravan Kumar Gopisetty

• Sep 1st, 2006

1.Understand the bussiness requirements.2.Once the business requirements are clear then Identify the Grains(Levels).3.Grains are defined ,design the Dimensional tables with the Lower level Grains.4.On...

prashanthmcr

 Profile Answers by prashanthmcr Questions by prashanthmcr

• Aug 29th, 2006

You can also the book "The Datawarehouse Toolkit" By ralph kimball and margy ross. I found it extremely helpful.PrashanthCheck the website www.intelligententerprise.com . It is quite informative and has very useful articles.

Answer Question  Select Best Answer

ramakrishna.inf

 Profile Answers by ramakrishna.inf Questions by ramakrishna.inf

• Apr 21st, 2009

Static cache - It doesn't reflect changes once data is cached is known as static cache.

Dynamic cache - It reflect to changes at the time of running the session if any updates happen in source data.

jayadhar

• Sep 4th, 2006

static cache stores overloaded values in the memory and it wont change throught the running of the session where as dynamic cache stores the values in the memory and changes dynamically duirng the run...

Answer Question  Select Best Answer

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