If you're looking for SAS DI Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research, SAS DI has a market share of about 2.9%... So, You still have opportunity to move ahead in your career in SAS Data Integration Developer. Mindmajix offers Advanced SAS Data Integration Interview Questions 2019 that helps you in cracking your interview & acquire dream career as SAS Data Integration Programmer.
Q1) Explain Data Dimension?
Data Dimension in the SAS DI is defined as the data in between the customers, products, and organization that can be accessed with the governance of data. Generally, we need to acquire the best support of all the business data views with great self-service reporting. With the help of this data dimension, you can completely view the strength and capability of the clients, products as well as the organization.
Q2) Explain Data Access?
The Data Access in SAS Data Integration is defined as an approval that was selected by the particular business users for the sake of large data loads.
Q3) Define Data Governance?
Data Governance in the Data Integration is a repeatable, affordable and robust process, which downstream all the down checks. This process will able to manage all the updates that can maintain all the consistency of the data.
Q4) What is Exception reporting in DI?
The exception reporting in the DI is mainly used to report the data which include more data issues.
Q5) Explain multi-dimensional reporting?
The multidimensional reporting in the DI will allow the users to make the aggregate analysis for the business metrics across the wide range of business dimensions.
Q6) What is meant by dimension tables in DI?
The dimension table in SAS Data Integration is defined as the integral component for the fact table, as it contains the more textual explanations regarding the business. These dimension tables in the DI is a well-designed model which may contain more attributes and columns, as they will describe the dimension of the row table and serves as the main source of reporting labels.
Subscribe to our youtube channel to get new updates..!
Q7) Explain the data staging area in DI?
The staging area in the DI is defined as the data warehouse which can store the data and process it normally in order to extract more transformation. This data staging will always happen in between the data presentation area as well as the operational source systems.
Q8) Describe star schema and snowflake schema?
The star schema in the DI is described as the set of the database where the single fact table is subjected to the multiple dimension tables, whereas the snowflake schema is stated as the single fact table is interlinked to the multiple sets of dimension tables in order to reduce all the themes.
Q9) Explain the main difference between the primary key and unique key?
Unique key in the DI is nothing but a key which contains one, two or more columns, which can be usually used to identify the particular row in a table. The value of the unique key is always equal to null, whereas the primary key has one values that don't have a null value.
Q10) What is meant by SAS metadata server, SAS application server?
The SAS metadata server in the data integration will be able to provide all the metadata management services according to the request that will be raised on the client application. While the SAS application will directly provide their immense services to the customers without any hassle.
Q11) Explain the terms operational system and operating data?
The operational system in the data integration of SAS will have a set of multiple programs which can provide the major source for the particular data warehouse, whereas the operational data can provide the single source for an entire data warehouse.
Q12) Describe the importance of SAS Management Console?
The SAS management Console in the Data Integration is mainly used to provide the great user interface in order to perform all the tasks that are done by the SAS administration.
Q13) Determine the transformation that can be used in the SAS data integration?
Metadata Object is the transformation, which is used in the SAS DI in order to evaluate the process of extracting data into respective data stores.
Q14) List out few data transformation which is used in the SAS DI?
The following are some of the listed data transformations which are mainly used in the SAS DI:
- Fact table lookup
- Data transfer
- Data Validation
- Surrogate key generator
- SAS Sort, SAS splitter, SAS rank
Q15) What is metadata object?
Metadata object is nothing but a group of attributes which describes a server, a user, a table and other resources on a network.
Q16)Explain the change analysis in SAS Data Integration?
In SAS Data Integration, change analysis is used to identify the differences between two sets of metadata and also compare 1 set to another set of metadata.
Q17)Write a brief description about interaction table in SAS Data Integration?
In SAS Data Integration, interaction table tells the relationship between 2 or more tables.
Ex: consider the intersection table which describes the many - to - many relationships between table of groups and table of users.
Q18)Explain about the scheduler and mention name of the scheduler for scheduling the job?
CONTROL-m is the scheduler for scheduling the job and also process flow, view, and dependencies for the user. So, they can optimize business processes efficiently, easily and data in a center which includes different platforms like Microsoft, Windows, VMS, and Unix.
Q19)what is the differences between foreign key, primary key, surrogate key, retained key, alternate key, generated key and business key?
- Foreign key: It has 1 or more columns which are related to unique key or primary key in another table and also dependent upon its related keys in the table. We can have more than one foreign key in one table. We cannot apply foreign key in the table without primary key or unique key in another table.
- Primary key: primary key is defined as that columns contain unique and not null values.
- Surrogate key: When rows are added and updated then the surrogate key generate unique integer values sequentially. In order to connect to specific dimensions in the fact table, and the surrogate key includes as a foreign key.
- Retained key: In dimension table, the primary key has numeric column is nothing but a retained key of that table.
- Alternate key: Unique key in the table is also said to be alternate key.
- Generated key: It is used to identify the unique rows in the table and contain only one primary key. There are no null values which contain the primary key. The generated key is used to implement the retained keys and surrogate keys.
- Business key: The dimension table has one or more columns which comprise the primary key in the source table.
Q20)Explain the cons and pros of the SAS DI?
By enabling the rapid generation of data warehouses, data streams and data marts which reduces the development time of SAS data integration. The SAS DI sometimes can have performance issues and generate very complex code that is very hard to decode.