Interested to Buy Any Domain ? << Click Here >> for more details...
What is a candidate key?
- 7 Answers
- 15907 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 |
What are the features of complex mapping?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the use of Data Mart?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
how eliminate the duplicates in flat file with out using sorter ,aggregater
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
what is target load plan
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Teradata 
