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

 Print  |  
Question:  Transformation keys into generic key by system itself is called as



February 02, 2009 14:00:06 #1
 aquacooldude   Member Since: February 2009    Total Comments: 1 

RE: Transformation keys into generic key by system itself is called as
 
The transformation of keys which are supposed to be used as primary key into generic key by the system is called as key restructuring.


The problem is something like this, let us a say there was an existing system
for keeping record of each house in a town. The uniqueness of the house was
represented by a 4 character word where first two characters give the house
number and the last two characters represent the street name.


Then the town expanded into a big city and correspondingly the house number
changed. Now the first two digits of the same house changed in the unique key.
To avoid such changes and have a generic key for uniqueness, key restructuring
is done by the system.


     

 

Back To Question