surrogate keys usage in Oracle and Informatica?

Answer Posted / ranjan

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we create index after completion of load process?

600


How to generate sequence numbers using expression transformation?

648


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1792


State the differences between sql override and lookup override?

629


What is meant by a domain?

633






How to delete duplicate row using informatica?

615


What is Data Caches size?

658


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


Please let me know how to make Data masking in informatica..

1272


can u any challenge your project?

1612


What are junk dimensions?

636


What are the designer tools for creating transformations?

687


What do you understand by SOA of Informatica?

592


What is the advantage of informatica?

650


what is the complex transformation you used in informatica

2194