Explore topic-wise InterviewSolutions in .

Types of loops available in DATASTAGE:

• Numeric Loop: It is a type of loop DIVIDED into three parts, From (the initialization value), STEP (the increment value for each counter), and To (the FINAL counter value).
• List Loop: It is a type of loop containing two parts, i.e., Delimited Values(which includes the values inside the list) and the Delimiter(space, comma, or any other character) in which you are required to PERFORM a loop for each item present in a list.

Here are the STEPS to successfully KILL a JOB in Datastage:

• First, GO to the Job Resources dialog box and choose the range of processes to list by through the Show All or Show by job option present in the Processes area.
• Now, to kill all the processes associated with a particular job, click on Logout All.
• If you want to end a specific process only, then select the method in the list box, and then click on Logout.
• Now, you will have to wait for the process to end and the display to be updated.

Job control in Datastage PROVIDES a method of controlling VARIOUS jobs from a current job. In this, a set of one or multiple jobs can be validated, run, STOPPED, reset, and SCHEDULED in almost the same WAY as the current job. Users can set up a job where the only function is to control the set of other various jobs.

In Datastage, duplicates can be removed using the four ways:

• Through the Duplicate Removal Stage
• Using the Hash File Stage.
• Using a sort stage and setting ALLOW DUPLICATES: false
• It can be done at any stage by doing a hash portion of the INPUT data and CHECKING OPTIONS under Sort and UNIQUE.

Here are some NECESSARY STEPS to set up a Merge in Datastage:

• Go to the Stage page Properties Tab
• Now, specify the key column or columns to be merged
• Inside the Stage page Properties Tab, you need to set the Unmatched Masters Mode, Warn on Reject Updates, in addition to setting the Warn on Unmatched Masters options or accept the defaults.
• After that, in the Stage page Link Ordering Tab, you need to check if your INPUT links are correctly IDENTIFIED as "master" and "update(s)," and the output links are defined as "master" and "update reject."
• Most importantly, you need to ensure the required column metadata is specified
• Finally, go to the Output Page Mapping Tab and specify the order of mapping the columns from the input links map to the output columns.

Here are the features of the Datastage Flow Designer:

• It has the palette for easy dragging and dropping of connectors and operators onto the designer canvas.
• Here the nodes can be easily linked by selecting the PREVIOUS node and dropping the NEXT node or by merely drawing the link between the two nodes.
• Stage properties on the side-bar can be edited and to make CHANGES to your schema in the Column Properties tab.
• There is an option to zoom in and zoom out using your mouse.
• There is no need to migrate jobs
• You don't need to upgrade servers or purchase virtualization technology licenses.
• You can easily HIGHLIGHT all compilation errors in ONE go.

In Datastage, the Conductor Node is used for the primary process of starting jobs, determining resource assignments, and CREATING the section leader processes on various processing nodes. It acts as a single responder to COORDINATE the status and error messages while also MANAGING the PROPER shutdown in the event of process completion or the occurrence of a fatal error. It is handled and run from the primary server.

Technically, Datastage is an ETL TOOL that is used in extracting data, transforming, and loading it from the source to the TARGET. It is a Data integration component used in the IBM INFOSPHERE Information System.

• Used to integrate different types of data
• Used in BIG Data for the integration of data at rest or motion
• Used in Mainframe and Distributed Architectures for Data Integration
• Plays a major in Business ANALYSIS by providing valuable information for Business Intelligence.