A fact build has been created that includes a Product Code dimension element. Each incoming product code must match a corresponding row in the Product dimension. What should the developer do?
Answer : B
A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?
Answer : B
Which of the following is a use for a fact build?
Answer : B
What distinguishes an OLTP system from a data warehouse? (choose two)
Answer : A,E
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
Answer : C
A developer wants to copy data from one table to a table in another database. What type of fact build would be the most appropriate for the developer to specify in the Fact Build wizard?
Answer : B
A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?
Answer : C
Why has the developer selected the Output box for the ProductLine row?
Answer : A
A text file contains a row at the top that only identifies the names of the columns. In order for this file to be processed successfully, what must the developer do in SQLTXT
Designer?
Answer : D
Which of the following is are characteristics of surrogate keys? (choose three)
Answer : A,E,F
End users must be able to create Cognos 8 reports using data from the data warehouse.
To facilitate this, what can the developer do from within Data Manager?
Answer : C
The data in the Product dimension table appears as follows:
What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?
Answer : D
When delivering fact data to a text file, what can be specified?
Answer : A
Which of the following is true of packages in Data Manager?
Answer : D
To reduce memory usage, what should be done when setting up dimension breaking for a fact build?
Answer : A