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

what is SDLC way of code development?

1566


What is meant by target load plan?

561


How are the sources and targets definitions imported in informatica designer?

672


What are the features of complex mapping?

650


When do you use sql override in a lookup transformation?

591






write a query to retrieve the latest records from the table sorted by version(scd)

638


Describe data concatenation?

578


How do you load only null records into target? Explain through mapping flow.

1509


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

557


What is an expression transformation in informatica?

523


How to extract sap data using informatica? What is abap? What are idocs?

561


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1658


What is rank transform?

605


What are the guidelines to be followed while using union transformation?

643


where to store informatica rejected data? How to extract the informatica rejected data?

607