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
- 6559 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
What are the databases that informatica can connect to windows?
How can we create index after completion of load process?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can you please explain me pre session and post session options?
Write the different tools in the workflow manager?
What are the informatica performance improvement tips
What are the uses of etl tools?
what is the -ve test case in your project.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
tell me the rules and responsblites in our project(my project is development)
What is the Process to creating lookup transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
How do you handle two sessions in Informatica
How does a sorter cache works?
In development project what is the process to follow for an etl developer from day1
