InfoSphere DataStage v8.0 Certification Examination Dump
Exam Name: InfoSphere DataStage v8.0 Exam Type: IBM
Exam Code: 000-418 Total Questions: 131
Page 1 of 39 : Sample Certification Dump
Question: 1
Your job uses the MQ connector stage to read messages from an MQ queue. The job should
retrieve the message ID into the MessageID field and parse the payload into two fields: Name is to get the first ten characters, Description is to get the remaining characters. What will accomplish this?
A. First column is MessageID as Binary 24; second column is Name as Binary 10; select
WSMG.MSPAYLOAD data element; third column is Description as VarBinary 200; select
WSMG.MSPAYLOAD data element.
B. First column is MessageID; select the WSMQ.MSGID data element for the Message ID
field;second column is Description as VarBinary 200; third column is Name as Binary 10.
C. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name; select WSMG.MSPAYLOAD data element; third column is
Description; select WSMG.MSPAYLOAD data element.
D. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name as Binary 10; third column is Description as VarBinary 200.
Answer: D
Question: 2
Which two methods can be used for adding messages to a message handler? (Choose two.)
A. Import message handler from existing message handler dsx.
B. Drag and drop a message from the job log onto the message handler.
C. Type in the message rule by hand.
D. Use the add rule to message hander interface.
Answer: C, D
Question: 3
Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)
A. Change the lookup option in the stage properties to "Sparse".
B. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
C. Establish a relationship between the key field column in the source stage with the database table field.
D. Sort the data on the reference link.
Answer: A, C
Question: 4
What describes the column information specified in Orchestrate schemas? (Choose two.)
A. C++ data types, such as string[max 145]
B. Column properties, such as nullability
C. SQL data types, such as Char(20)
D. Record format information, such as record delimiter
Answer: A, B
*** Click Here to Read More Question and Answers... Which will help you to clear examinations.. ***
Exam Name: InfoSphere DataStage v8.0 Exam Type: IBM
Exam Code: 000-418 Total Questions: 131
Page 1 of 39 : Sample Certification Dump
Question: 1
Your job uses the MQ connector stage to read messages from an MQ queue. The job should
retrieve the message ID into the MessageID field and parse the payload into two fields: Name is to get the first ten characters, Description is to get the remaining characters. What will accomplish this?
A. First column is MessageID as Binary 24; second column is Name as Binary 10; select
WSMG.MSPAYLOAD data element; third column is Description as VarBinary 200; select
WSMG.MSPAYLOAD data element.
B. First column is MessageID; select the WSMQ.MSGID data element for the Message ID
field;second column is Description as VarBinary 200; third column is Name as Binary 10.
C. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name; select WSMG.MSPAYLOAD data element; third column is
Description; select WSMG.MSPAYLOAD data element.
D. First column is MessageID; select the WSMQ.MSGID data element for the Message ID field; second column is Name as Binary 10; third column is Description as VarBinary 200.
Answer: D
Question: 2
Which two methods can be used for adding messages to a message handler? (Choose two.)
A. Import message handler from existing message handler dsx.
B. Drag and drop a message from the job log onto the message handler.
C. Type in the message rule by hand.
D. Use the add rule to message hander interface.
Answer: C, D
Question: 3
Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)
A. Change the lookup option in the stage properties to "Sparse".
B. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
C. Establish a relationship between the key field column in the source stage with the database table field.
D. Sort the data on the reference link.
Answer: A, C
Question: 4
What describes the column information specified in Orchestrate schemas? (Choose two.)
A. C++ data types, such as string[max 145]
B. Column properties, such as nullability
C. SQL data types, such as Char(20)
D. Record format information, such as record delimiter
Answer: A, B
*** Click Here to Read More Question and Answers... Which will help you to clear examinations.. ***
No comments:
Post a Comment