What is a candidate key?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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,

6755


Different sorts of metadata that stores in the storage facility?

561


How to create the source and target database connections in server manager?

631


How do you handle two sessions in Informatica

669


Design a mapping to load the cumulative sum of salaries of employees into target table?

898






Describe data concatenation?

574


Explain your project of banking domian.

1220


How many numbers of sessions can one group in batches?

623


What are the different types of transformation available in informatica.

639


What is exclusive and normal mode for repository services?

713


how to create user defined function (udf) in informatica

785


How can we create index after completion of load process?

600


How can repository reports be accessed without sql or other transformations?

729


Could you explain what is enterprise data warehouse?

555


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

698