Interested to Buy Any Domain ? << Click Here >> for more details...
what is an sid (surrogate key)?
- 4 Answers
- 10317 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arkchowdary
Surrogate Key----------------- It is a System Generated Key
they are not derived from any Data Sources.
Surrogate Key----------------- It is a Unique Identifier.
Surrogate Key----------------- It is used to identify each
Row of a table uniqely.
Surrogate Key---------------- It also helps to track Slowly
Changing Dimensions.
Surrogate Key---------------- It replaces all Natural Keys.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
Answer / bhaskar.nagi
It is a System Generated Key. It is act as a Primary Key.
| Is This Answer Correct ? | 1 Yes | 0 No |
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is metric store database?
Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....
Define the slice and dice?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
what is exact catalog size?
How do we run stored procedure?
what is boxtype
What is called cognos reporting tool?
when can i use the STAR Schema and SNOWFLAKE Scgena
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
Teradata 
