Sample Questions:

You are working in a multi-user central repository based environment. You select "Rename owner" on an object which is not checked out. The object has one or more dependent objects in the local repository. What is the outcome?

Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified. Data Integrator renames the individual object owner.

Data Integrator displays the "This object is checked out from central repository "X".

Please select Tools Central Repository. to activate that repository before renaming Message.

Data Integrator renames the owner of all 0bjects within the selected data store.

Your data flow loads the contents of "order_details "and" order_headers "into one XML file that contains a node and a child mode . How should you populate the structure in your Query?

In the HEADER schema use the order headers for from and leave where empty in the detail schema use the order details for From and Where clause put order_header_id =order_details order_id

In the HEADER schema use the order_headers for from and put order_header.order_id = order details.order_id in where clause. In the detail schema use the order_details for from and leave where empty.

In the header schema use the order_header for from and leave where empty in the detail schema use the order_header for from and put order_header order_id = order_details order_id in where clause

In the header schema use the order_headers for from, and in where clause put order_header order_id = order details order_id in the detail schema use the order_header, order_details for from and leave where empty.

You create a data flow that contains an XML file as the output. The XML file structure contains an element that is used to group other element. This element occurs once in the output XML file. Which method can you use to ensure that this element is populated correctly? For interactive and self-paced preparation of exam DMDI301, try our practice exams. Practice exams also include self assessment and reporting features.

Enter the value"1" in the single element schema mapping.

Leave the form clause of the single element schema empty

Place the source table that contains your source rows into the form clause of the single element schema.

Use a row_Generation transform and select one row then map the transform into the from clause of the single element schema.

Data integrator conations "Execute only once" logic on which two objects?

Conditionals

Data flows

Scripts

Work flows

You create a real-time job that processes data from an external application. Which two mechanisms enable the external application to send/receive messages to the real-time job? (Choose two).

Adapter instance

File on shared server

E-mail

Web service call

You are sourcing COBOL data from a Mainframe. Which three COBOL features does native data integrator support? (Choose three).

OCCURS DEPENDING

REDEFINES

RECORD OCCURS

ISAM

Which two interfaces requires an adapter data store? (Choose two).

COBOL copybook

MQ series

Sap R/3

Web service