iPass4sure.net

Certification Practice Test | PDF Questions | Actual Questions | Test Engine | Pass4Sure

DMDI301 : BusinessObjects Data Integrator XI - Level Two Exam

Business-Objects DMDI301 Questions & Answers

Full Version: 33 Q&A


Latest DMDI301 Exam Questions and Practice Tests 2025 - Killexams.com


DMDI301 Dumps DMDI301 Braindumps DMDI301 Real Questions DMDI301 Practice Test DMDI301 Actual Questions


killexams.com Business-Objects DMDI301


BusinessObjects Data Integrator XI - Level Two


https://killexams.com/pass4sure/exam-detail/DMDI301


D. to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')


Answer: A


QUESTION: 25

You have a production job that retrieves data from your oracle 10g operational source system and loads the data into your data warehouse. The operations of the source system are complaining that the data integrator load process is causing the system to perform poorly. Which two actions can you take to reduce the impact data integrator jobs have on the source system? (Choose two)


  1. Implement a CDC data store for the source system t reduce the number of rows extracted.

  2. Increase the value of the "array _fetch_size" parameter on the source table.

  3. Perform intensive operations such as "group by" and "joins" in a staging area instead of on the source system.

  4. Use "linked data stores" to connect the source and target data stores.


Answer: A, B


QUESTION: 26

Your data integrator environment interprets year values greater than 15 as 1915 instead of 2015. you must ensure data integrator interprets any date from "00 to 90" as "2000 to 2090" without making direct modifications to the underlying data flow. Which method should you use to accomplish this task?


  1. Log into the designer and select tools l Options l data l General and modify the "Century change year" to 90.

  2. Open the server manger and select edit job server config and modify the "Century change year to 90".

  3. Open the web administration tool and select management l requisiteness edit theproduction requsitury and modify the "Century change year to 90".

  4. On the job server, open the windows l control panel l regional settings l Customize data and modify the two digit year interpretation to 90.

  5. Configure the source database to interpret the two digit dates appropriately.


Answer: A


QUESTION: 27


You load over 10,000.000 records from the "customer" source table into a staging area. You need to remove the duplicate customer during the loading of the source table. You do not nee tot record or audit the duplicates. Which two do-duplicating techniques will ensure that best performance? (Choose two.)


  1. Use a Query transform to order the incoming data set an use the previous_row-value in the where clause to filter any duplicate row.

  2. Use the Query transform to order the incoming data set. Then a table_comparison transform with "input contains duplicates" and the "sorted input" options selected.

  3. Use tha table_ comparison transform with the "input contains duplicates" and "cached comparison table" selected.

  4. Use the lookup_ext function. With the Pre_load_cache" option selected to test each row for duplicates.


Answer: A, B


QUESTION: 28

You want to join the "sales" and "customer" tables. Both tables reside in different data stores. The "sales" table contains approximately five million rows. The "customer" table Contains approximately five thousand rows, the join occurs in memory. How would you set the source table options to maximize the performance of the operation?


  1. Set the sales table joins tank to 10 and the cache to "No" then set the customer table join tank to 5 and cache to "yes".

  2. Set the sales table joins tank to 10 and the cache to "yes" then set the customer table join tank to 5 and cache to "yes".

  3. Set the sales table joins tank to 5 and the cache to "Yes" then set the customer table join tank to 10 and cache to "No".

  4. Set the sales table joins tank to 5 and the cache to "No" then set the customer table join tank to10 and cache to "No".


Answer: A


QUESTION: 29

Where can the XML_Pipeline transform be used within a data flow? (Choose two)


  1. Immediately after an XML source file.

  2. Immediately after an XML source message.

  3. Immediately after a Query containing nested data.

  4. Immediately after an XML template.


Answer: A, B


QUESTION: 30

You create a two stage process for transferring data from a source system to a target data warehouse via a staging area. The job you create runs both processes in an overnight schedule. The job fails at the point of transferring the data from the satging area to the target data warehouse. During the work day you want to return the job without impacting the source system and therefore want to just run the second stage of the process to ransfer the data from the staging area to the data warehouse. How would you design this job?


  1. Create two data flows the first extracting the data from the source system the second transferring the data to the target data warehouse.

  2. Create one data flow which extracts the data form the source system and uses a data_transfer transform to stage the data in the staging area before then continuing to transfer the data to the target data warehouse.

  3. Create two data flows the first extracting the data from the source system and uses a data_tranfer transform to write the data to the staging area. The second data flow extracts the data from the staging area and transfers it to the target data warehouse.

  4. Create one data flow which extracts from the source system and populates both the staging area and the target data warehouse.


Answer: A


QUESTION: 31

Which two data integrator objects/operations support load balancing in a server Group based architecture? (Choose two.)


  1. Job

  2. Lookup_ext

  3. Script

  4. While loop


Answer: A, B


QUESTION: 32

You have a data flow the read multiple XML files form a directory by specifying wildcard in the file name. which method can use to link the XML file name to the records being read?


  1. Select "include file name column" in the XML source file.

  2. Use the function get_xml file name in the query mapping

  3. Use the column "XML_fileNAME" listed at the top of the XML file structure.

    Use the variable$ current_XML_file in the query mapping


Answer: A


QUESTION: 33

You are trying to improve the performance of a simple data flow that loads data from a source table into a staging area and only applies some simple remapping using a Query transform. The source database is located on the wan. The network administrator has told you that you can improve performance if you reduce the number or round trips that occur between the data integrator job server and the source database. What can you do in your data flow to achieve this?


  1. increase the array reach size parameter in the source table editor

  2. Increase the commit size in the target table editor.

  3. Increase the commit size in the source table editor.

  4. Replace the source table with the SQL transform.


Answer: A


User: Raphaël*****

Word of mouth is a powerful marketing tool, and when something is so good, positive publicity is a no-brainer. I would like to spread the word about Killexams.com, which helped me perform outstandingly well in my DMDI301 exam, exceeding all expectations. I think Killexams.com is one of the most admirable online teaching ventures and it deserves a lot of recognition.
User: Florencia*****

In my opinion, using killexams.com was a good way to prepare for the exam. Although not all the questions on the exam were identical to what I had seen on killexams.com, over 70% were the same and the rest were very similar. However, passing the exam is the most important thing, and I managed to do so. It is essential to remember that even with killexams.com, it is still necessary to learn and use your brain.
User: Jacob*****

Recently, I purchased the dmdi301 exam practice tests package deal from Killexams.com and studied it thoroughly. Last week, I passed the dmdi301 and received my certification. The Killexams.com exam simulator was an excellent tool to prepare for the exam, boosting my confidence and helping me easily pass the certification exam. I am quite encouraged by this experience.
User: Maxine*****

I passed the DMDI301 exam on my first attempt, and I owe my success to Killexams.com. Their comprehensive study materials provided me with valid and reliable practice questions, and the exam simulator helped me gain a complete understanding of the exam. Thank you, Killexams.com, for your invaluable assistance.
User: Ammar*****

Thanks to Killexams.com, I managed to crack my dmdi301 exam on the first attempt with a score of 72.5% after just two days of preparation. Their valuable questions made the exam much less intimidating. I look forward to passing more exams with their help.

Features of iPass4sure DMDI301 Exam

  • Files: PDF / Test Engine
  • Premium Access
  • Online Test Engine
  • Instant download Access
  • Comprehensive Q&A
  • Success Rate
  • Real Questions
  • Updated Regularly
  • Portable Files
  • Unlimited Download
  • 100% Secured
  • Confidentiality: 100%
  • Success Guarantee: 100%
  • Any Hidden Cost: $0.00
  • Auto Recharge: No
  • Updates Intimation: by Email
  • Technical Support: Free
  • PDF Compatibility: Windows, Android, iOS, Linux
  • Test Engine Compatibility: Mac / Windows / Android / iOS / Linux

Premium PDF with 33 Q&A

Get Full Version

All Business-Objects Exams

Business-Objects Exams

Certification and Entry Test Exams

Complete exam list