why we are using surogate key in real time give me
explanation

Answers were Sorted based on User's Feedback



why we are using surogate key in real time give me explanation..

Answer / nagendra phani

SUROGATE KEY is used to generate a primary key. and it is
system generated number

Is This Answer Correct ?    4 Yes 1 No

why we are using surogate key in real time give me explanation..

Answer / davan

Mainly we r using...the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is a code page?

1 Answers  


why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,


What is operational data source (ODS)?

7 Answers  


What is rank transform?

1 Answers  


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


What is a stored procedure transformation?

1 Answers  


What aer the out put files that the informatica server creates during the session running?

4 Answers  


Explain constraint based loading in informatica

1 Answers   Informatica,


hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  


write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,


Categories