what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?

Answer Posted / kalpana

Some times the primary constraint may violate at that time
we go for surrogate key.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of aggregator transformation?

589


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1633


wat are deployement groups in informatica, how it will be used for developers

1266


Explain transaction control transformation in informatica

771


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1616






How to do unit testing in informatica?

735


How do you convert single row from source into three rows into target?

615


how tokens will generate?

1745


Difference between Data and Index Caches?

668


What is a predefined event?

672


what is the Default Source Option For Update Strategy Transformation?

768


What are the tuning techniques you applied during your last project

1573


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1869


what is mean by complex business rule ?

1727


Which transformation is needed while using the Cobol sources as source definitions?

736