what are surrogate keys?
Answers were Sorted based on User's Feedback
Answer / sai suresh
surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deepthi pathuri
A surrogate key in a data warehouse is more than just a
substitute for a natural key.
(OR)
A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pradeep
surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.
Is This Answer Correct ? | 0 Yes | 1 No |
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
What happens when a session fails and you click on recover?
What is Cognos script editor?
What are the parts of Informatica Server?
what is pre and post sql and what is diff between source presql and target pre sql
what r the transformations that r not involved in mapplet?
Why we need XMLs?
What are the challenges you have faced in your project?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Name 4 output files that informatica server creates during session running?
How can you generate reports in informatica?