what is the purpose of surrogate key and diff between primary
key&surrogate key
- 1 Answers
- 5885 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / suresh
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 |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
State the differences between sql override and lookup override?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of schemas we have in data warehouse and what are the difference between them?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is unit testing?tell me proceedure
What is option by which we can run all the sessions in a batch simultaneously?
How we can create indexes after completing the loan process?
What is meant by incremental aggregation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Why union transformation is an active transformation?
What is the advantage of informatica?
What are mapplets?
