GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 146 of 302    Print  
what is the difference between type 1& type 2 dimension

  
Total Answers and Comments: 2 Last Update: March 21, 2007     Asked by: pratap 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 11, 2007 23:20:03   #1  
ravi        

RE: what is the difference between type 1& type 2 dime...
In type-1 dimesnion we have only the current dimension data.We overwrite the the old dimension data with the new dimension.

In type-2 , we basically keep the entire history of data and for we add additional row to the changed dimension as a new row with the changed values.

In short it keeps the full historical data what happened before.

 
Is this answer useful? Yes | No
March 21, 2007 11:21:25   #2  
vizaik Member Since: March 2007   Contribution: 30    

RE: what is the difference between type 1& type 2 dime...
there are 3 scd types
scd type1:  Only current details
scd type2:  History + current details
scd type3:  Initial + current details




In projects, we mainly use scd type1

 
Is this answer useful? Yes | No

 Related Questions

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ...

Latest Answer : CREATE OR REPLACE  PROCEDURE TIMEDIMBUILD   (p_start_date IN DATE,  p_end_date IN DATE)AS  v_full_date DATE;  v_day_of_month NUMBER; v_day_of_year NUMBER;  v_day_full_name VARCHAR2(30); v_week_number  ...

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Read Answers (4) | Asked by : Deshaireddy

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
Read Answers (4) | Asked by : pratyusha

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Read Answers (5) | Asked by : kishore

What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?

Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ...
Read Answers (3) | Asked by : senthilkumarselvaraj

Latest Answer : Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools. ...
Read Answers (1) | Asked by : karthik mani

Latest Answer : global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1 ...
Read Answers (2) | Asked by : raj


 Sponsored Links

 
Related Articles

What is Data Dimension

Data Dimension is mainly used in data warehouse implementations. A data warehouse is implemented to that organizations can profit from data driven operation which constitute a major component in running businesses these days. To be effective with a data driven operation, data which is the basis for
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

The Difference Between Data Mart and Data Warehouse

The Difference Between Data Mart and Data Warehouse The biggest decision facing most IT managers today is whether or not they should construct the data mart before the data warehouse Many vendors will tell you that data warehouses are hard to build as well as expensive mosgoogle If you listen to som
 

Type Conversions in C++

Type Conversions in C In this C Tutorial you will learn about Type Conversions in C What is Type Conversion How to achieve this Automatic Conversion otherwise called as Implicit Conversion and Type casting otherwise called as Explicit Conversion mosgoogle What is Type Conversion It is the process of
 

XML - Elements in Document Type Definitions (DTD)

XML Elements in Document Type Definitions DTD In this tutorial you will learn about Elements in DTD Elements child elements nested elements declaring elements with character data only declaring elements with mixed content declaring elements with any content declaring elements with no content and ele
 

XML - Document Type Definitions (DTD)

XML Document Type Definitions DTD In this totuorial you will learn about XML Document Type Definitions DTD Need DTD Types Of DTD’ s Internal DTD External DTD mosgoogle NEED XML documents can contain many different types of markups including elements attributes and entity references Whate
 

. NET Type Safety

NET Type Safety This Article discusses What is Type Safety in the context of NET What is Type Safety How does Type Safety affect us Why is Type Safety Important Writing Type Safe Code How is Type Safety ensured What is Verifiable Type Safe Code Verification process How to determine if the code is
 

Tutorial 66: MSAS - Applying security to a Dimension

When roles are assigned for cubes the user has access or no access to the cube When roles are assigned to a dimension the user gains only partial access to parts of the cube The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimens
 

Tutorial 48: MSAS - Introducing Dimension and Cube Processing

The Analysis server is like a black box Everything that happens in the server is recorded but the end user sees a multidimensional cube created out of the data in the data warehouse and has very little taste of what really goes on behind the scenes In this section we will be examining this black box
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape