C2090-421 무료 덤프문제 온라인 액세스

You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)

• A.Input columns must all be of the same data type.
• B.Columns must be in consecutive order.
• C.Input columns must form a numeric sequence.
• D.Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
• E.All columns are combined into a vector of the same length as the number of columns.

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

• A.Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.
• B.Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.
• C.Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.
• D.Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.

You are given a job requirement that requires calculations based on the latest currency exchange rate. You decide to invoke a Web service to obtain the latest exchange rate.
What are two ways that you can perform a Web service invocation in a DataStage job to obtain the latest exchange rate? (Select two)

• A.Use Web Services Transformer stage.
• B.Use WISD Input stage.
• C.Call a Web Service using a DSRoutine inside the Parallel Transformer stage.
• D.Use Web Services Client stage as a lookup.

Which of the following describes what happens when Runtime Column Propagation is enabled?

• A.An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.
• B.An input column value flows into a target column only if it is explicitly mapped to it.
• C.An input column value flows into a target column based on its position in a Schema file.
• D.An input column value flows into a target column only if it matches it by name.

Which three statements are true about characteristics of shared containers? (Select three)

• A.Containers are a group of stages and links.
• B.Containers allow you to implement recurring logic.
• C.Containers allow multiple users to access a single job.
• D.Containers are used to execute jobs.
• E.Containers allow you to provide pre-configured job design logic.