kamesh

• Jan 30th, 2018

Incremental loading is defined as the activity for only loading new records and updated records from a database into an established in a Quick view detect Batch processing is the process of series of ...

Andrey Parkhomets

• Feb 27th, 2012

cross reference table used to describe many-2-many relation between tables. aggregate fact table - when granularity of fact data not required fact can be grouped over dimensions, measures will be af...

Answer Question  Select Best Answer

kamesh

• Jan 30th, 2018

A Dimension which is derived from the fact table and doesnt have its own dimension table A degenerate dimension is a transaction based number. A degenerated dimensions are often called as textual fact...

TimeBeing

• Jan 25th, 2017

A Dimension table which have the values of Fact table is called "De-Generated Dimension".

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

kamesh

• Jan 30th, 2018

A join is linked with only only one dim and one fact is called star schema
A join is linked with more than one dimension is called Snow flake schema.

sunny

• Jul 5th, 2013

star schema: When dimension table contains less number of rows, we can go for Star schema.In this Both Dimension and Fact Tables are in De-Normalized form.Good for datamarts with simple relationships ...

Answer Question  Select Best Answer

Kamesh

• Jan 30th, 2018

ER represent the logical design technique that seeks to eliminated the data redundancy It shows the relationship between the data.
DM is a logical technique that seek to present the data in standard intuitive to allow high performance access.

Sreedhar Lokaray

• Nov 3rd, 2011

I think the answer the best suits this question is as below: Entity - Relationship Modelling:- Removes data redundancy. Ensures data consistency. Expresses relationship between the entities....

Answer Question  Select Best Answer

Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)

kamesh

• Jan 30th, 2018

A join is linked with only one dimension and one fact is called Star chema

TimeBeing

• Jan 25th, 2017

A Fact table is surrounded by multiple Dimension tables and which is look like STAR in graphical design is called "STAR Schema".

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: saravanan

• Dec 2nd, 2005

---

Surrogate key is a unique identification key, it is like an artificial or alternative key to production key, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high

P.Manideep

• Oct 29th, 2017

Surrogate key is system generated key. It is a column or set of columns declared as primary key instead of real of natural key.

Anukul Thawarey

• Aug 8th, 2017

Just to add on to this point, we can also have date stamp as in the format (yyyymmdd) which is actually an 4 Byte unsigned integer to keep track of the historical data. This date stamp column can also be considered as an surrogate key.

Improve Answer

Answered by swetha on 2005-03-30 12:00:33: OLTP  Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery is necessary   OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...

ram

• Aug 30th, 2016

OLTP: Original Source of data
Running on fundamental business task

OLAP: Data coming from various OLTP sources
Problem Solving, Decision Making

Pravin

• Jan 16th, 2015

Very useful answer.
thanks.

Answer Question  Select Best Answer

EssamGad

• Apr 16th, 2016

No, Actually there is something called Rapidly Changing Dim or Fast Growing Dim, it is the Dim that contains an attribute that changes frequently. and one solution is to move this attribute to a new mini dim with a separate foreign key in the fact table.

dipanshu handoo

• May 26th, 2012

A dimension is considered to be a rapidly changing dimension if one or more of its attributes changes frequently in many rows. For a rapidly changing dimension, the dimension table can grow very large from the application of numerous Type 2 changes.

Answer Question  Select Best Answer

Piyush Shah

• Feb 5th, 2014

One to many.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

ankeshjain  

 Profile Answers by ankeshjain Questions by ankeshjain

• Member Since Aug-2008 | Aug 17th, 2008

---

1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
 

Ravi Teja N

• Sep 16th, 2011

The steps used to develop a DWH are 1. Gathers Operational Source System 2. Data Staging Area 3. Data presentation Area 4. Data Access Tool Lets have a detailed information about each stage: Operat...

mohanbabu

• Aug 20th, 2011

We can create the dwh in two ways i.e
1. top down approach
2.bottom up approach

Improve Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jun 5th, 2011

surrogate key is a substituted key for the business key in data warehouseThis is generated while the loading process (ETL)attributes of surrogate key1) It has the same granularity of the Business Key ...

bcsandip

 Profile Answers by bcsandip Questions by bcsandip

• Oct 8th, 2010

Along with Jeff's answer, the surragate key also distinguish 2 records with the same combined primary key in the denormalized DWH tables where history is maintained.

Answer Question  Select Best Answer

Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes.

Read Best Answer

Editorial / Best Answer

Answered by: Edmond

• Apr 13th, 2007

---

Let's be very clear. this is a very simple, and becomes a very confusing subject.
A fact table is an entity representing the numerical measurements of the business. A dimension table is the entity describing the textual representation of the business.

In a banking model, the account and balances are the measurements within the fact table, where customer name, social security, address, time period of the account, are the dimensions (customer/time).

Hope this answers the clarification.

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jun 5th, 2011

In very simple termsFact : this contains all numeric attributesDimesion : this contains all non numeric , textual attributesIn order to rememberFact : Any answer to What user want to see is factfor ex...

mickey_gupta

 Profile Answers by mickey_gupta Questions by mickey_gupta

• Mar 4th, 2009

Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data.

Improve Answer

Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization.  1N.F:- The table should caontain scalar or atomic values. 2 N.F:- Table should be in 1N.F + No partial functional dependencies 3 N.F :-Table should be in 2 N.F + No transitive dependencies

dstorkey

 Profile Answers by dstorkey Questions by dstorkey

• Mar 24th, 2009

To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key.

Jyothsna Tallapally

• May 10th, 2006

Normalization:It is the process of efficiently organizing data in a database.There are 2-goals of the normalization process: 1. Eliminate redundant data 2. Ensure data dependencies make sens...

Answer Question  Select Best Answer

Give an example of non-additive facts?

rummyraj

 Profile Answers by rummyraj Questions by rummyraj

• Oct 13th, 2010

Here is an actual example from my current project.We sell Parts globally. Each part is being sold at different price in different regions. Each part has different cost to the company in different regi...

Answer Question  Select Best Answer

What is the use of bridge table. Can give a simple example?

Read Best Answer

Editorial / Best Answer

Sirini  

 Profile Answers by Sirini Questions by Sirini

• Member Since Jun-2009 | Jun 14th, 2009

---

An example of a Bridge table would be relationship table between student_master and courses_master. A Student may participate in multiple courses and obviously in a course there will be multiple students. In this scenario to maintain relationships between student_master and courses_master we need another table, which may be called, Student_courses. This table will have all relationships between Students and Courses.A bridge table is a table that only contains the keys between the two tables in a many-to-many relationship. These tables typically consist of mostly key fields, the primary keys of the two tables needing the many to many relationships. Sometimes there are more data elements, but often there are only two columns, both foreign keys.

vijsarav11

 Profile Answers by vijsarav11 Questions by vijsarav11

• Oct 19th, 2009

Hi all... This is my view on bridge tables:Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id...

tisha24

 Profile Answers by tisha24 Questions by tisha24

• Oct 7th, 2009

A table which maintained to define the relationship between two different tables is known as bridge tables. For example, say there are two tables one table with employee information (an employee table...

Improve Answer

mri_sonam

 Profile Answers by mri_sonam Questions by mri_sonam

• Dec 17th, 2008

Factless Fact Table is the fact table without having any measure (Transaction Data).The intention may vary from use but mostly its used for either Custom Reporting or Bridging. It contains only the k...

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Oct 3rd, 2008

Best way of explaining the purpose of factless fact table is factless fact tables are the prefered method of recording evernts in a data warehouse where there is no natural numberic measurement associated with the event.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

jaggu_mandya  

 Profile Answers by jaggu_mandya Questions by jaggu_mandya

• Member Since Jan-2008 | Jan 17th, 2008

---

OLTP(1)---->ODS(2)------>DWH(3)-------->OLAP(4)------------>Reports(5)------>decision(6)

1-2 (extraction)
2-3 (Transformation and here ODS is itself staging area )
3-4-5 (Use of reporting tool and generate reports)
6-decision is taken i,e purpose of datawarehouse is served

I think this is right picture

wnthanuja

 Profile Answers by wnthanuja Questions by wnthanuja

• Jun 19th, 2008

Source System data ----------Extraction---------Transformation(Clenance the data according to business logics)(As dimensions)----------Takes data from the dimension tables in to fact tables using Surrogate keys---------------Load (As cubes)(In to the staging)

verma_tushar

 Profile Answers by verma_tushar Questions by verma_tushar

• Mar 5th, 2008

In some of the cases Pre Stage is also a intermediate phase between the OLTP environment and actual staging area.The prestage is one where dta clensing, data profiling nad data validation takes place....

Improve Answer

DWAlchemist

 Profile Answers by DWAlchemist Questions by DWAlchemist

• Apr 11th, 2008

A snowflake schema is a way to handle problems that do not fit within the star schema.  It consists of outrigger tables which relate to dimensions rather than to the fact table.The amount of spac...

ghoshkunal123

 Profile Answers by ghoshkunal123 Questions by ghoshkunal123

• Feb 5th, 2008

Star schema is good for simple queries and logic. But snowflake schema is good for complex queries and logic. Snowflake schema is nothing but an extension of the star schema in which the dimension tables are further normalized to reducy redundancy. Hope this helps.

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