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

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

639


What could be the possible resons of locks by user?

665


What is the way to execute pl/sql script using informatica mapping?

963


Name at least 5 different types of transformations used in mapping design and state the use of each.?

670


What is a surrogate key?

563






What is session task and command task?

649


Explain what are the different versions of informatica?

655


Explain sql transformation in script mode examples in informatica

605


can we override a native sql query within informatica? Where do we do it?

626


What are batches?

623


What are the uses of etl tools?

647


During the running session, output files are created by informatica server. Enlist few of them.

542


How can you define user defied event?

622


What is sorter transformation?

585


How to go to the older version for a mapping?

604