What is a candidate key?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

lookup transformation with screenshots

3555


Why do you use Mapping Parameter and mapping variable?

1280


How an expression transformation differs from aggregator transformation?

624


How many ways a relational source definition can be updated and what are they?

575


What is the surrogate key?

631






What is resilience time?

651


Write the unconnected lookup syntax and how to return more than one column.

590


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1123


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1576


What is a dimensional model?

581


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1503


Enterprise data warehouse your projects phase by phase explain?

1458


How can we store previous session logs?

565


Can informatica load heterogeneous targets from heterogeneous sources?

693


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2133