000-418 무료 덤프문제 온라인 액세스

Which two system variables/techniques must be used in a parallel Transformer derivation to generate a unique sequence of integers across partitions? (Choose two.)

• A.@NUMPARTITIONS
• B.@INROWNUM
• C.@PARTITIONNUM
• D.@INROWNUM+1

You have a nullable input column that can be mapped to a non-nullable output column.
Which three NULL handling techniques can be used in the Transformer stage for that column? (Choose three.)

• A.If input_column = then
• B.NullToEmpty(input_column)
• C.If input_column = NULL then
• D.NullToValue(input_column)
• E.If IsNull(input_column) then

Click the Exhibit button.
You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?

• A.Set "Output mode" setting "Aggregate all rows" under "Transformation Settings" of the Output link of an XML Output stage.
• B.Set "Output mode" setting "Separate rows" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.
• C.Set "Output mode" setting "Use Trigger" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.
• D.Set "Output mode" setting "Single row" under "Transformation Settings" of the Output link of an XML Output stage.

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

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

Which three lookup types may be performed in the Lookup stage? (Choose three.)

• A.Equality match
• B.Range on stream link
• C.Negative match
• D.Range on the reject link
• E.Range on the reference link