Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajdeep chatterjee
Surrogate key is an artificial key which is a system
generated one. It can be created from Oracle using
sequence, can also be created using ETL tools. It is the
unique key is dimension tables. The purpose of using
Surrogate key is to reduce the dependency from underlying
database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
can you tell me what are the dimension tables are used in project
Can you define folder?
What is difference between primary key and unique key constraints?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
How do we convert from Numeric to be Words?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
Name the types of report?
What is difference between content store and content manager?
What DB View and Bus View?
whats the difference between previous version of cognos and cognos 8 BI?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
How is possible this scenario using in type-in prompt.?
What is drill down and slicing and dicing whats the difference between them?
Explain what is the difference between native sql and cognos sql?
