SAS DI Certification Notes For A00-260

If you are preparing for SAS DI Certification (A00 -260), the following notes could help you to clear it

• For register table wizard in SAS Data Integration Studio, Metadata for the selected physical table or tables would be stored in the specified SAS folder location which is specified in the wizard


• If we register the metadata for an ODBC data source, it would involves registering a server definition that points to the ODBC data source and a library accessing this server definition


• SAS Data Integration Studio is dependent on an administration function which is setting up of SAS Application Servers


• The ability to deploy a SAS Data Integration Studio job as a web service or a SAS Stored process requires an additional set up that would be performed in SAS Management Console


• The metadata for the library tables is NOT defined as a part of new library wizard


• Use the New User Written External file wizard to register an external file with the following structure like : First, Second, Third and fourth line contains following information respectively : First name, Last name, Address and Phone number


• In SAS DI Studio, COBOL Copybook is NOT an available option from the file - new menu choice under External file grouping


• System DSN is not specific to an individual user, Anyone with permission to access the data source can use it


• The Return Code check transformation can be added to the job flow immediately following the Extract and Sort transformation - The Status handling tab in each of the Return Code Check Transformations properties can then establish the desired status handling


• While writing postcode in the Precode and Postcode tab of the Transpose Transformation in SAS DI Studio &SYSLAST allows us to reference the transformation output table regardless of the actual physical name for the target table


• Ampersand Sign (&) on the top left corner of any transformation denotes that, that object has a defined parameter


• With the help of Data Validation Transformation, we can create a job that checks condition for our data before the data would be loaded into a data warehouse. This job should be able to  detect error conditions such as missing data or duplicate data and take appropriate action like registering error conditions in log etc.


• In SAS DI Studio, we can create three type of expression by using the Expression Builder window in Where Tab of SAS Extract Transformation which are : SAS Expression, SQL Expression and a Constant