Interested to Buy Any Domain ? << Click Here >> for more details...
What is a candidate key?
- 7 Answers
- 15915 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique). Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / subramanyam
A key that uniquely identifies rows in a table. Any of the
identified candidate keys can be used as the table's
primary key. Any of the candidate keys that is not part of
the primary key is called an alternate key. One can
describe a Candidate Key as a Super Key that contains only
the minimum number of columns necessary to determine
uniqueness.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / lavanya
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / surendra
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more columns is
called composite key.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sivakumar
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique).One of these candidate keys is selected as
the table primary key else are called Alternate Key. Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to update or delete the rows in a target, which do not have key fields?
Why we use ENABLE HIGH PRECISION in session properties?
Issue with Update override at Target table in Informatica.
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the surrogate key?
Design time, run time. If you don't create parameter what will happen
If we have lookup table in workflow how do you trouble shhot to increase performance?
In ur current projectu have done any performance tuning of mappings?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What is data caches/ index caches?
Explain why we use partitioning the session in informatica?
Teradata 
