IBM DataStage and ETL Fundamentals

Questions about IBM InfoSphere DataStage tool including its components, stages, partitioning methods, and ETL concepts

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

A Workflow fails and you need to consult the logs. Which power center application will allow to check session and workflow logs?

  1. Designer
  2. Admin Console
  3. Workflow Manager
  4. Workflow Monitor
Question 2 Multiple Choice (Single Answer)

Which is NOT a valid way to start a workflow?

  1. Right-click the workflow workspace and select Start workflow
  2. Issue a Start Workflow command from the Admin console
  3. From the Command line, using pmcmd
  4. In Workflow Manager, use the Workflows-> Start Workflow option
Question 3 Multiple Choice (Single Answer)

PHP server scripts are surrounded by delimiters, which?

  1. <?php>...</?>
  2. <?php…?>
  3. <script>...</script>
  4. <&>...</&>
Question 4 Multiple Choice (Single Answer)

What is the correct way to include the file "time.inc" ?

  1. <!--include file="time.inc"-->
  2. <?php include_file("time.inc"); ?>
  3. <?php require("time.inc"); ?>
  4. <% include file="time.inc" %>
Question 5 Multiple Choice (Single Answer)

What can you use to replace like with hate in I like Eminem?

  1. preg_replace("like", "hate", "I like Eminem")
  2. preg_replace("/like/", "hate", "I like Eminem")
  3. preg_replace("/like/", "/hate/", "I like Eminem")
  4. preg_replace("hate", "like", "I like Eminem")
Question 6 Multiple Choice (Single Answer)

What library do you need in order to process images?

  1. c-client library
  2. GIF/PNG library
  3. Image Library
  4. GD library
Question 7 Multiple Choice (Single Answer)

What does this function do:

  1. tests whether $variable is a number and ends in 2
  2. tests whether $variable ends in 2
  3. tests whether $variable is a number and contains 2
  4. tests whether $variable is an even number
Question 8 Multiple Choice (Single Answer)

Dallas Semiconductor was founded in

  1. 1984
  2. 1990
  3. 1989
  4. 1975
Question 9 Multiple Choice (Single Answer)

The java ring is first introduced at

  1. JavaTwo Conference
  2. Orlando
  3. Celebration school
  4. None of these
Question 10 Multiple Choice (Multiple Answers)

Java Ring can be used for

  1. Starting the car
  2. Authentication
  3. Audit trails
  4. Adjusting room temperature
Question 11 Multiple Choice (Single Answer)

Protocol used in smart card of the java ring

  1. TCP/IP
  2. FTP
  3. UDP
  4. APDU
Question 12 Multiple Choice (Single Answer)

Expansion for ETL

  1. Exact Transform Load
  2. Extract Transform Load
  3. Exec Transform Load
  4. Except Transform Load
Question 13 Multiple Choice (Single Answer)

Datastage is tool of

  1. Microsoft
  2. Sun Microsystems
  3. IBM
  4. Oracle Corporation
Question 14 Multiple Choice (Single Answer)

Where do we design a datastage job?

  1. Director window
  2. Designer window
  3. Administrator Window
  4. Palette
Question 15 Multiple Choice (Single Answer)

What is expansion of RCP

  1. Random Column Propogation
  2. Remove Column Propogate
  3. Runtime Column Propogation
  4. Real-time Column Propogation
Question 16 Multiple Choice (Multiple Answers)

Which two stages allow reject links? (Choose two.)

  1. Join stage
  2. Merge stage
  3. Funnel stage
  4. Lookup stage
Question 17 Multiple Choice (Multiple Answers)

List 2 types of keyless partitioning

  1. Entire
  2. Same
  3. Hash
  4. Modulus
Question 18 Multiple Choice (Single Answer)

) Which Stage Takes a single data set as input and assigns each input record to an output data set based on the value of a selector field.

  1. Filter stage
  2. Merge stage
  3. Funnel stage
  4. Switch stage
Question 19 Multiple Choice (Single Answer)

Which Client Component is used to import & export the project to view & edit the contents of the repository?

  1. Administrator
  2. Manager
  3. Designer
  4. Director
Question 20 Multiple Choice (Single Answer)

Where do we check the log?

  1. Administrator
  2. Manager
  3. Designer
  4. Director