Stephen

• Apr 6th, 2007

Junk Dimension also called as garbage dimension. A garbage dimension is a dimension that consists of low-cardinality columns such as codes, indicators, status,and flags. The garbage dimension is also referred to as a junk dimension. Attributes in a garbage dimension are notrelated to any hierarchy.

Rajkumar

• Sep 5th, 2006

A junk dimension is a convenient grouping of flags and indicators. It's helpful, but not absolutelyrequired, if there's a positive correlation among the values. Their benefits: Provide a rec...

Answer Question  Select Best Answer

kalyani

• Mar 28th, 2007

Source qualifier is a transformation which extracts data from the source. Source qualifier acts as SQL query when the source is a relational database and it acts as a data interpreter if the source is a flatfile.

sandrag

 Profile Answers by sandrag Questions by sandrag

• Feb 7th, 2007

Source qualifier is an transformation which every mapping should have , it defines the source metadata to the Informatica Repository.The source qualfier has different properties like filtering records , and joining of two source , and so on .

Answer Question  Select Best Answer

testuser

• Mar 15th, 2007

Date and time (If datetime data type is not supported then you have to have hour/min/sec on a seperate columns)WeekMonthQuarterYear

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Raghunath Bhairavajosula

• May 12th, 2006

Generally we load the Time dimension by using SourceStage as a Seq File and we use one passive stage in that transformer stage we will manually write functions as Month and Year Functions to load the ...

Answer Question  Select Best Answer

A cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. This arrangement avoids the more costly alternative of storing and maintaining copies of a cube on multiple analysis servers. linked cubes can be connected using TCP/IP or HTTP. To end users a linked cube looks like...

Amit Sagpariya

• Nov 20th, 2006

Hi All,Could you please let me know what is Replicate Cube & Transparent Cube?Thanks & regards,Amit Sagpariya

Amit Sagpariya

• Nov 20th, 2006

Hi All,Could you please let me know what is Replicate cube &

Answer Question  Select Best Answer

Shiva

• Nov 11th, 2006

 Any schema or Table or Report which gives you meaningful information  of  one attribute  wrt more than one attribute is called  a cube.For Ex: In a product tab...

Answer Question  Select Best Answer

chandu

• Nov 1st, 2006

A fact,which can be used across multiple datamarts is called as conformed fact.

praveen_pspk

• Sep 9th, 2006

Confirmed dimensiobs are the dimensions that we can use across multiple datamarts in combination with fact tables.Ex: Time dimension

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

Sphurti

• Aug 16th, 2006

I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and foreign key data needs to...

smithareddy

• Jul 19th, 2006

Normalized View-> Process of eliminating the redundencies.Denormalized View-> process the data where duplication takes place. Which means it is not stop the replication.

Answer Question  Select Best Answer

Kalai

• Jul 29th, 2006

There are four methods in which one can build a datawarehouse.1. Top-Down (Emphasizes the DW. )2. Bottom-Up (Emphasizes data marts.)3. Hybrid (Emphasizes DW and data marts; blends ?top-down? and ?bott...

Loveojha

• May 18th, 2006

There can be actually three methodology as suggested by Ralph Kimball1. Top Down Approach (Build using a Big Bang Approach, which takes time and result won't be visible very quickly, but will be more ...

Answer Question  Select Best Answer

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

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

Answered by sudhakar on 2005-05-09 18:32:18: star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...

sk.rafee

 Profile Answers by sk.rafee Questions by sk.rafee

• Apr 26th, 2006

Star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...

Guest

• Feb 13th, 2006

Star Schema                                &n...

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

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

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

J Lehew

• Aug 25th, 2005

Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. &nb...

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