×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?
2.
When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?
3.
Consider the job flow diagram in the display. Which of these objects has parameters defined for it?
4.
You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.
5.
In the following display, can status handling be enabled for the Extract transformation?
6.
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?
take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?
7.
Given the table below as a source table for the Transpose transformation in SAS Data Integration Studio:
In the Options tab in the Properties window for the Transpose transformation, if the columns are assigned as follows:
Select columns to transpose (VAR statement): Payment
Select a column for Output column names (ID statement): Month Select columns whose values define groups of records to transpose (BY statement): Name
Which of the following tables is a possible resulting target table?
In the Options tab in the Properties window for the Transpose transformation, if the columns are assigned as follows:
Select columns to transpose (VAR statement): Payment
Select a column for Output column names (ID statement): Month Select columns whose values define groups of records to transpose (BY statement): Name
Which of the following tables is a possible resulting target table?
8.
Within SAS Data Integration Studio, which type of expression can be created using the Expression Builde window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an
XML expression 4) a constant
XML expression 4) a constant
9.
Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?
10.
Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?