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

What is meant by a domain?

632


What is data movement mode in Informatica and difference between them?

628


Can we override a native sql query within informatica?

632


What are the transformations that are not supported in mapplet?

604


What is the Process to creating lookup transformation in informatica

589






What are active transformations.

1194


In which transformation you cannot drag ports into it?

795


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


What is dynamic cache?

614


Explain incremental aggregation in informatica

661


What is an expression transformation?

594


What's the layout of parameter file (what does a parameter file contain?)?

1919


What is meant by query override?

640


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1854