When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data? A. business key columns B. Type 1 columns C. generated columns D. non-key columns
The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following? A. generate cpu statistics B. generate a datetime value C. generates cluster numbers D. generates standardization values
Which action is performed by the Lookup transformation in SAS Data Integration Studio? A. combines rows from multiple tables into a single row B. combines rows from multiple tables into multiple rows C. validates that values are unique D. validates…
In SAS Data Integration Studio, where must the columns included in a business key exist? A. in the source and standardization tables B. in the source and dimension tables C. in the target and fact tables D. in the source,…
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following? A. find row matches using the business key B. find row matches using generated cluster numbers C. find non-standard values using a generated…
In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values? A. datetime values B. alpha-numeric values C. binary values D. integer values
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected? A. the old record is deleted and the changed record is added B. the old record is updated…
A fact table is populated by using which transformation in SAS Data Integration Studio? A. SCD Type 2 Loader B. Data Validation C. Lookup D. DataFlux IS Job
In SAS Data Integration Studio, surrogate and retained key values are: A. generated by the Lookup transformation B. copied from source tables into dimension tables C. generated by the SCD Type 2 Loader transformation D. copied from dimension tables into…
In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation? A. Data Validation B. Lookup C. DataFlux IS Job D. Table Loader