Interested to Buy Any Domain ? << Click Here >> for more details...
what are surrogate keys?
- 5 Answers
- 11517 Views
- I also Faced
- E-Mail Answers
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 |
How can you change from reusable session into non-reusable session.
In update strategy target table or flat file which gives more performance ? why?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
Whats the difference between $, $$, $$$
what is the difference between stop and abort?
What are session parameters ? How do you set them?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
checkout and checkin in informatica 8.6
Teradata 
