Interested to Buy Any Domain ? << Click Here >> for more details...
What is a candidate key?
- 7 Answers
- 15620 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 |
If u r using dynamic cache lookup port will be thier in thet which option u will select
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to start a workflow using pmcmd command?
What is hash partition?
what is the necessity to use update strategy?(except for updates)
one source to target loading insert new rows and update existing rows?
How to go to the older version for a mapping?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Explain lookup transformation source types in informatica
What is meant by target load plan?
Teradata 
