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  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 71 of 111    Print  
What is hybrid slowly changing dimension

  
Total Answers and Comments: 4 Last Update: August 14, 2007     Asked by: senthil 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 02, 2006 09:25:05   #1  
Satyaranjan Puthal        

RE: What is hybrid slowly changing dimension

what ever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT and in target mentaining the history. If Not clear then reach me at 09910232910


 
Is this answer useful? Yes | No
August 06, 2006 03:43:01   #2  
Rishi Pahuja        

RE: What is hybrid slowly changing dimension

Let me give an example to make the point clear....

Like account information is usually maintained in two categories:

Current Account and other is Time of Event Account i.e We have two set of tables eg CUR_ACCT this is fast moving dimension containing information like Balance etc , while the other is TOE_ACCT table this contains information like Contact Details, Phone No where history is not only important but considered to be changing slowly.

With this respect TOE_ACCT table qualiefies as slowly changing dimension.


 
Is this answer useful? Yes | No
August 08, 2006 05:44:31   #3  
Pradeep Menon        

RE: What is hybrid slowly changing dimension

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 some columns even if the data changes, we don't care.

For such tables we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
August 14, 2007 01:34:09   #4  
Are Ramakrishna Rao        

RE: What is hybrid slowly changing dimension
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)

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




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