Online Access Free 000-418 Exam Questions

You would like to verify that a job in the QA project is identical to the one in development project. How can you do this?

• A.Compare the job description annotation fields of the two jobs.
• B.Select the job in question and use the cross project compare utility.
• C.From the repository tree, select the cross project compare utility.
• D.Compare the job version number.

A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a WISD output stage. What are two ways that parameter values can be passed to this job at run-time? (Choose two.)

• A.Pass the parameter values at the time of the service request.
• B.Execute a DSSetParam with the values at job execution time.
• C.Include the parameter values in the data.
• D.Change the properties of the information provider and redeploy.

Which three data types can the ODBC Enterprise stage handle? (Choose three.)

• A.SQL_CLOB
• B.SQL_SMALLDATETIME
• C.SQL_VARBINARY
• D.SQL_TIMESTAMP
• E.SQL_BIGINT

You need to accumulate totals for all input records from a sequential file based on month, without regard to day or year. The output is to a sequential file. The columns appear as CUSTID Varchar(12), Sale_date Date, and sale_amount Decimal (5,2). Which series of stages would accomplish this task in the shortest time?

• A.Sequential File -> Transformer -> Aggregator -> Sequential File
• B.Sequential File -> Aggregator -> Sequential File
• C.Sequential File -> Sort -> Aggregator -> Sequential File
• D.Sequential File -> Transformer -> Remove Duplicates -> Sequential File

What describes the column information specified in Orchestrate schemas? (Choose two.)

• A.Column properties, such as nullability
• B.SQL data types, such as Char(20)
• C.Record format information, such as record delimiter
• D.C++ data types, such as string[max 145]