What is the difference b/w natural key and surrogate key
- 1 Answers
- 4723 Views
- I also Faced
- E-Mail Answers
Answer / babulcity
Natural Key is key attribute column of an entity with
distinct values i.e without duplicates/NULL.
Eg: For natural Key we can define constraint like PK,FK
Surrogate Key is an substitute key which is not a part of
attribute of entity & is unique but it can be used to act as
PK,FK when you cannot use the Natural key.
| Is This Answer Correct ? | 2 Yes | 0 No |
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is deployemnt groups, Lables, query and dynamic deployment group.
What is facttable granularity?
how to we create datamart?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What are active and passive transformations?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
Explain how many types of dimensions are available in informatica?
What are set operators in Oracle
Why update strategy and union transformations are active?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
How to generate sequence numbers?
Teradata 
