Category Archives: Data Stage Interview Questions

What is merge stage? | Data Stage Questions

The Merge stage combines a sorted master data set with one or more sorted update data sets. The columns from the records in the master and update data sets are merged so that the output record contains all the columns … Continue reading

Posted in Data Stage Interview Questions | Leave a comment

How do u convert the columns to rows in DataStage? | Data Stage Questions

Using Pivot Stage.

Posted in Data Stage Interview Questions | Leave a comment

What are Routines? | Data Stage Questions

Routines are the functions which we develop in BASIC Code for required tasks, which we DS is not fully supported (Complex).

Posted in Data Stage Interview Questions | Leave a comment

What is staging variable? | Data Stage Questions

These are the temporary variables created in transformer for calculation.

Posted in Data Stage Interview Questions | Leave a comment

What is hash file stage? | Data Stage Questions

Hash file stage is binary file used for lookup, for better performance.

Posted in Data Stage Interview Questions | Leave a comment

What are the types of Containers? | Data Stage Questions

There are two types of containers are : Local Container Shared Container

Posted in Data Stage Interview Questions | Leave a comment

What are the components of Ascential Data Stage? | Data Stage Questions

Client Components : Administrator, Director, Manager, and Designer. Server Components : Repository, Server and Plug–ins.

Posted in Data Stage Interview Questions | Leave a comment

What is the difference between DataStage version 5.2 and 6.0? | Data Stage Questions

Version 5.2 doesn’t have – IPC Stage ,Link Partition Stage,Link Collector Stage and Parallel Extender.

Posted in Data Stage Interview Questions | Leave a comment

What is dynamic array? | Data Stage Questions

Dynamic arrays map the structure of Data Stage file records to character string data. Any character string can be a dynamic array. A dynamic array is a character string containing elements that are sub strings separated by delimiters.

Posted in Data Stage Interview Questions | Leave a comment

What is universe stage? | Data Stage Questions

A stage that extracts data from or loads data into a Universe database using SQL. Used to represent a data source, an aggregation step, or a target data table.

Posted in Data Stage Interview Questions | Leave a comment