What is surrogate key?

Answer Posted / latha

actually it appears in picture when a critical
column(example location) occurs in a table.In order to avoid
the critical column we are using surrogate key.surrogate key
is also a primary key.

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transformation in informatica

693


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5832


Explain sql transformation in script mode examples in informatica

607


Define joiner transformation?

598


How many transformations can be used in mapplets.

1464






When do you use sql override in a lookup transformation?

591


Describe the impact of several join conditions and join order in a joiner transformation?

649


Explain the mapping variable usage example in informatica

635


What are the popular informatica products?

653


How we can create indexes after completing the load process?

616


What is the Process to creating lookup transformation in informatica

587


What is meant by incremental aggregation?

589


Explain about Informatica server process that how it works relates to mapping variables?

627


How can we improve session performance in aggregator transformation?

678


How to create a non-reusable instance of reusable transformations?

686