What is a candidate key?

Answer Posted / vikas

A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique). Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1509


What is an active transformation?

648


How to delete duplicate row using informatica?

615


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


without table how to come first record only in oracle?

1861






Define the various join types of joiner transformation?

561


is it possible to index the data in cache of lkp transformation ?

1528


What is main use of mapplet?

664


What is a mapplet/worklet in informatica?

692


What is different between the data warehouse and data mart?

630


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8567


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

902


What is decode in informatica?

663


Make a note of the quantity vaults made in informatica?

561


Explain transaction control transformation in informatica

763