Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of surrogate key and diff between primary
key&surrogate key
- 1 Answers
- 6558 Views
- Cap Gemini, I also Faced
- E-Mail Answers
primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.
surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.
| Is This Answer Correct ? | 5 Yes | 2 No |
What are the mapping parameters and mapping variables?
Is it possible to update the target table with PK?
What is a design?
What is the difference between STOP and ABORT options in Workflow Monitor?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What is the need of etl tools?
what is target update override and when we use it?
What is a dimensional model?
How can yoU create or import flat file definition in to the warehouse designer?
What is a difference between complete, stop and abort?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Teradata 
