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

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

Question Posted / venkat

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..

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

More Informatica Interview Questions

How to merge First Name & Last Name?

What are the transformations that are not supported in mapplet?

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

What is difference between partioning of relatonal target and partitioning of file targets?

What is a passive transformation?

What does command task mean?

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

What could be the possible resons of locks by user?

Explain what are the different types of transformation available in informatica.

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

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

For more Informatica Interview Questions Click Here