what is the purpose of surrogate key and diff between primary
key&surrogate key
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 |
Describe an informatica powercenter?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What are the Advantages of de normalized data?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Different sorts of metadata that stores in the storage facility?
How to use Normalizer transformation?
What is Micro Strategy? Why is it used for?
Whats there in global repository
how to move the mappings from your local machine to claint place?
What is the difference between router and filter?
What is the difference between Bulk Load and Normal Load