A fact build has two data sources that need to undergo the same calculation for every input row, and the data will be merged. Where should the derivation be created? A. In the DataStream. B. In each data source. C.…
Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how…
A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already…
Which of the following is true of a derivation that has been created in the transformation model? A. The derivation cannot be disabled once it has been added to the transformation model. B. The derivation can be added to a…
A developer has created a derivation in a data source. When will this derivation be calculated? A. As each row is retrieved from the data source. B. After the source data is pivoted, but before it is merged and aggregated.…
Which of the following is true of transformation model derivations? A. They can be created within a static member. B. They can consist of a string literal. C. They can be used as sources for an attribute element. D. They…
When this JobStream is executed, what is the maximum number of nodes that will run in parallel at any one time? A. 3 B. 4 C. 7 D. 8
In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE. What will happen if this node fails while the JobStream is executing? A. Data Manager will immediately stop processing the remaining dimension build…
A fact build has been created that will extract data for all of Europe. All of the data will be delivered to fact tables. The developer wants to direct United Kingdom-specific data into its own fact table. What must be…
A developer has created a fact build to process the incoming data shown in the table: The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior…