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 for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?
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 created on the fact delivery?
When this JobStream is executed,
what is the maximum number of nodes that will run in parallel at any one time?
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 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 exists in this table, the existing row must be updated accordingly. What should the developer do?
Currently there are no comments in this discussion, be the first to comment!