What is a candidate key?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

607


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702


What is flashback table ? Advance thanks

1484


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2074


Did u used latest transformations of 8.6.0? for what?

1481






What are some examples of informatica etl programs?

540


What are the different types of transformation available in informatica.

641


How to join three sources using joiner? Explain though mapping flow.

704


What is the use of target designer?

612


what is the complex transformation you used in informatica

2194


On which transformations you created partitions in your project?

763


What all are steps in up gradation of Informatica server?

624


Sequence generator, when you move from develoment to production how will you reset

1412


What are roles and groups and benefits of using them?

573


What are the types of caches in lookup? Explain them.

554