2014 Latest Pass4sure&Lead2pass IBM C2090-418 Practice Tests

Vendor: IBM
Exam Code: C2090-418
Exam Name: IBM WebSphere DataStage v.8.0

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

» Read more