Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario: When a BI environment is being loaded with historical transactions (as a factual detail) an existing customer dimension record may be referenced for setting

Scenario: When a BI environment is being loaded with historical transactions (as a factual detail) an existing customer dimension record may be referenced for setting a value as a foreign key on a fact table. Some of these statements about a CUSTOMER dimension table are true. Others are suspect. Check only those that make sense.

A CUSTOMER record should only be inserted into a customer dimension after at least a first transaction has been processed in a source application database.

A CUSTOMER record is often inserted for any person or business that is expected to conduct business with a company.

A CUSTOMER record is subject-oriented, non-volatile, time relevant evidence that financial activity has taken place.

A CUSTOMER record is recognized whenever activity originating in an operational source application. If missing, a new customer record must be insert before the fact record can be processed.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions