what are surrogate keys?

Answer Posted / pradeep

surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a Integration service without a Repository service and vice versa?

731


How big was your fact table

1322


What is native users?

725


What is sequence generator transformation in informatica?

627


How do you set a varible in incremental aggregation

1451






What is joiner transformation?

587


can u give example for factless fact table

5527


Clarify the aggregator change?

600


How to start a workflow using pmcmd command?

715


Parameter and variable differences

1622


What is a predefined event?

662


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

615


What happens when a session fails and you click on recover?

661


Write the unconnected lookup syntax?

662


On which transformations you created partitions in your project?

763