what is surrogate key give example?
Answers were Sorted based on User's Feedback
Answer / pavan kumar
A Surrogate Key is a system generated sequence numbers to
be used as primary keys.
A Surrogate keys are used in maintaining the full history
in scd type2.
A Surrogate key is also known as Synthetic Key or
Artificial Key or Dimensional Key.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopal
Surrogate key is system generated unique key to maintain the duplicates values.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is Cognos Visualizer and Cognos Scripting?
Is it possible to apply access manager user rights in impromptu?
what is the difference between enterprise data warehouse and data warehouse
Explain the difference between powerplay transformer and power play reports?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
how u will determine the performence tune will occur either in report or system
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
Can you define drill down and drill up?
What are all the advantages of Cognos?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.