what is an sid (surrogate key)?

Answer Posted / madho

it's a duplicate key for primary key or unique key

when we need to maintain historical data instead of primary
key and unique key we use surrogate key...

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a data mart and a data warehouse?

535


What is defined as Query studio?

600


Can you explain cognos planning?

646


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

702


Explain difference between powerplay transformer and power play reports?

531






Explain what is the difference between microstrategy and cognos reporting tool?

531


What is the complex report you faced in real time?

1715


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1503


What is the difference between low affinity and high affinity connections?

544


What is called Cognos powerplay?

606


What are the main services provided by application tier?

549


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1521


What is cognos connection?

577


Explain the characteristics of cognos?

599


What are the steps to import the two data sources in framework manager?

601