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.

Answer / gopal

Surrogate key is system generated unique key to maintain the duplicates values.

6. Which of them will increase the performance?

1 Answers  

---

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

1 Answers  

---

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,

---

Can you define cognos powerplay?

0 Answers  

---

What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,

---

What is a Complex report and explain?

4 Answers   IBM, Satyam,

---

Can you define query studio?

0 Answers  

---

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

---

Difference betwween cognos report net architecture and cognos8 architecture

3 Answers  

---

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development

11 Answers  

---