In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?
Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)
In SAS Data Integration Studio, where must the columns included in a business key exist?
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line contains the phone number What action should you take to read this file?
A fact table is populated by using which transformation in SAS Data Integration Studio?
In the following display, can status handling be enabled for the Extract transformation?
You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?
Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?
Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?