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

How to generate sequence numbers?

622


Can we create multiple integration service on single repository?

705


can u any challenge your project?

1612


What is Session and Batches?

666


Tell me about MD5 functions in informatica

530






Why filter transformation is an active one?

565


How to configure mapping in informatica?

680


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1652


Which development components of informatica have the highest usage?

598


Write the prerequisite tasks to achieve the session partition?

654


What are the main issues while working with flat files as source and as targets ?

660


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1878


Is it possible to revert a global repository to local one and why?

615


What is complex mapping?

641


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554