what are surrogate keys?

Answer Posted / sai suresh

surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of caches in lookup?

564


explain one complex mapping with logic? sales project?

6142


What are the uses of etl tools?

645


How identifying bottlenecks in various components of informatica and resolving them?

577


Explain the difference between mapping parameter and mapping variable?

600






What is rank transform?

595


What is informatica? Why do we need it?

633


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6748


What is exclusive and normal mode for repository services?

709


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1548


Explain pmcmd command usage in informatica

699


what is song in infrmatica...?

1670


Explain why we use partitioning the session in informatica?

607


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1627


What is the sequence generator transformation in informatica?

609