IBM InfoSphere DataStage v8.5 Set 2

Question - 15 Maximum mark : - 23

Home
All Exams
IBM InfoSphere DataStage v8.5 Online Practice Exams
IBM InfoSphere DataStage v8.5 Set 2

A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?

Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next,process the
records without landing to disk. ✘ In a single job,use five separate FTP Enterprise stages with output links to a single Sort Funnel stage.Next,process the records withoutlanding to disk. ✘ In a single job,use three separate FTP Enterprise stages (one for each machine) with output links to asingle Sort Funnel stage. Next,processthe records without landing to disk. ✘ Create a sequence containing five separate DataStage jobs which each retrieve a single file andappend it to a common Data Set. Next,process the resulting Data Set in an sixth DataStage job. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

Manually break the file into multiple files by record type. ✘ Define record definitions on the Constraints tab of the Complex Flat File stage. ✘ Define record ID constraints on the Records ID tab of the Complex Flat File stage. ✘ Use a Modify stage to convert the output array from the Complex Flat File to a subrecord. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

Use parameters to identify file names. ✘ Generate unique file names by using a macro. ✘ Use DSJobInvocationID to generate a unique filename. ✘ Use a Transformer stage variable to generate the name. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

Named all stage and links the same. ✘ Named all stages and links based on what they do. ✘ Indicated all stage names within the job annotation. ✘ Named all stage and links with column names and ideas. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The given job processes large volumes of data using default partitioning, with sort/partition insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming that the business logic allows all of the following actions, which design change would improve the performance of this job?

Set the buffer mode to no buffer on the output links of both Data Sets. ✘ Use the Data Set Management Utility to combine both input Data Sets into a single source Data Set. ✘ Set the Preserve Partitioning option on both Data Sets and replace the Merge stage with a Sort Funnelstage. ✘ Before each input to the Merge stage,insert a Sort stage with Dont Group,Previously Grouped set onthe merge key. Specify SAME partitioning on all inputs. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

An update that overwrites the existing column value. ✘ An update that replaces the existing column value if a specified condition is satisfied. ✘ An update that retains the existing column value in a list and adds the new value to the list. ✘ An update the retains the existing column value in an historical row and creates a new row with the newvalue. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What are the three features of Information Server that allow you to deploy DataStage objects? (Select three)

istool dscc.exe $APT_COPY_TRANSFORMER Designer Client Export Information Server Manager

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have a dataset that is range-partitioned and sorted. Which technique is most efficient to create globally sorted data file?

Select Ordered collector method for the input link of the final Sequential File stage. ✘ Select SortMerge collector method for the input link of the final Sequential File stage. ✘ Insert Funnel stage before the final Sequential File stage and select Sequence as Funnel Type. ✘ Insert Funnel stage before the final Sequential File stage and select Sort Funnel as Funnel Type. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

Using the Dynamic Relational stage,use custom SQL to select all DISTINCT customer numbers from the order history table. ✘ Select all rows using the ODBC Connector stage,use a Sort Aggregator on customer number key toselect the maximum order date. ✘ Using the DB2 Enterprise stage,select all rows. Perform a unique Sort using customer number andorder date sort keys in ascending order. ✘ Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

What three statements are true with regards to restartable mode for an FTP Enterprise stage? (Select three)

Specify the-restartable_transfer option. Optionally specify a unique job_id for the transfer. File URIs that were transferred completely are not transferred again. Specify a checkpoint directory for the transfer using the -checkpointdir directory. Checkpoint files are written to /^"checkpoint directory">/pftpJobid_ <"jobid number">.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM InfoSphere DataStage v8.5 Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner