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  >  DataStage

 Print  |  
Question:  Differentiate Primary Key and Partition Key? 



Answer: Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, Random etc..While using Hash partition we specify the Partition Key. 




May 05, 2007 22:14:14 #1
 hanug   Member Since: June 2006    Total Comments: 24 

RE: Differentiate Primary Key and Partition Key? ...
 

Hi:

Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.

Partition key is the key that we use while partition the table(in database), process the source records in ETL(in the etl tools). We should define the partition based on the stages( in datastage) or transformations(in Informationca)  we use in the job(Datastage) or mapping(in Informatica).To improve the target load process, we use partition.


If u need more info, plz go through Database doc or Datastage or Informatica doc on partitioning.


Hanu.

     

 

Back To Question