Datastage Interview Questions and Answers, Datastage Interview Questions and Answers Freshers, Datastage Interview Questions and Answers, Datastage Interview Questions

Before getting on to the Datastage interview questions, the student must know that the Datastage is a continuously varying field which needs the students as well as professionals to upgrade their skills with the new features and knowledge, to get fit for the jobs associated with Datastage. This post related to Datastage Interview Questions and Answers, Datastage Interview Questions and Answers Freshers, Datastage Interview Questions and Answers, Datastage Interview Questions will help you let out find all the solutions that are frequently asked in you upcoming Datastage interview.

Over thousands of vacancies available for the Datastage developers, experts must be acquaintance with all the component of Datastage technologies. This is necessary for the students in order to have in-depth knowledge of the subject so that they can have best employment opportunities in the future. Knowing every little detail about Datastage is the best approach to solve the problems linked with problem.

APTRON has spent hours and hours in researching about the Datastage Interview Questions and Answers, Datastage Interview Questions and Answers Freshers, Datastage Interview Questions and Answers, Datastage Interview Questions that you might encounter in your upcoming interview.  All these questions will alone help you to crack the interview and make you the best among all your competitors.

First of all, let us tell you about how the Datastage technology is evolving in today’s world and how demanding it is in the upcoming years. In fact, according to one study, most of the companies and businesses have moved to the Datastage. Now, you cannot predict how huge the future is going to be for the people experienced in the related technologies.

Hence, if you are looking for boosting up your profile and securing your future, Datastage will help you in reaching the zenith of your career. Apart from this, you would also have a lot of opportunities as a fresher.

These questions alone are omnipotent. Read and re-read the questions and their solutions to get accustomed to what you will be asked in the interview. These Datastage interview questions and answers will also help you on your way to mastering the skills and will take you to the giant world where worldwide and local businesses, huge or medium, are picking up the best and quality Datastage professionals.

This ultimate list of best Datastage interview questions will ride you through the quick knowledge of the subject and topics like Datastage, RGBA and HSLA, Transforms, Animations. This Datastage interview questions and answers can be your next gateway to your next job as a Datastage expert.

These are very Basic Datastage Interview Questions and Answers for freshers and experienced both.

Q1: What is Datastage?
A1: Datastage is an ETL tool given by IBM which utilizes a GUI to design data integration solutions. This was the first ETL tool that gave
parallelism concept.

It is available in following 3 different editions
• Server Edition
• Enterprise Edition
• MVS Edition

Q2: Highlight the main features of Datastage?
A2: The main features of Datastage are highlighted below

  • It is the data integration component of IBM Infosphere information server.
  • It is a GUI based tool.We just need to drag and drop the Datastage objects and we can convert it to Datastage code.
  • It is used to perform the ETL operations (Extract, transform, load)
  • It provides connectivity to multiple sources & multiple targets at the same time
  • Provides partitioning and parallel processing techniques which enable the Datastage jobs to process a huge volume of data quite faster.
  • It has enterprise-level connectivity.

Q3: What are the primary usages of Datastage tool?
A3: Datastage is an ETL tool which is primarily used for extracting data from source systems, transforming that data and finally loading it to target systems.

Q4: What are the main differences you have observed between 7.x and 8.x version of DataStage?
A4: Here are the main differences between both the versions

7.x 8.x
7.x version was platform dependent This version is platform independent
It has 2-tier architecture where datastage is built on top of Unix server It has 3-tier architecture where we have UNIX server database at the bottom then XMETA database which acts as a repositorty and then we have datastage on top.
There is no concept of parameter set We have parameter sets which can be used anywhere in the project.
We had designer and manager as two separate clients In this version, the manager client was merged into designer client
We had to manually search for the jobs in this version Here we have quick find option in the repository where we can search easily for the jobs.

Q5: Can you highlight the main features of IBM Infosphere information server?
A5: Below are the main features of IBM Infosphere information server suite

  • It provides a single platform for data integration.It has the capability to connect to multiple source systems as well as write to multiple target systems.
  • It is based on centralized layers.All the components of the suite are able to share the baseline architecture of the suite.
  • It has layers for the unified repository, for integrated metadata services and common parallel engine.
  • It provides tools for analysis, cleansing, monitoring, transforming and delivering data.
  • It has massively parallel processing capabilities.It turns out the processing to be very fast.

Q6: What are the different layers in the information server architecture?
A6: Below are the different layers of information server architecture
• Unified user interface
• Common services
• Unified parallel processing
• Unified Metadata
• Common connectivity

Q7: What could be a data source system?
A7: It could be a database table, a flat file, or even an external application like people soft.

Q8: On which interface you will be working as a developer?
A8: As a Datastage developer, we work on Datastage client interface which is known as a Datastage designer that needs to be installed on the local system. In the backend, it is connected to the Datastage server.

Q9: What is the difference between Datastage 7.5 and 7.0?
A9: In Datastage 7.5 many new stages are added for more robustness and smooth performance, such as Procedure Stage, Command Stage, Generate Report etc.

Q10: In Datastage, how you can fix the truncated data error?
A10: The truncated data error can be fixed by using ENVIRONMENT VARIABLE ‘ IMPORT_REJECT_STRING_FIELD_OVERRUN’.

Q11: Define Merge?
A11: Merge means to join two or more tables. The two tables are joined on the basis of Primary key columns in both the tables.

Q12: Differentiate between data file and descriptor file?
A12: As the name implies, data files contains the data and the descriptor file contains the description/information about the data in the data files.

Q13: Differentiate between datastage and informatica?
A13: In datastage, there is a concept of partition, parallelism for node configuration. While, there is no concept of partition and parallelism in informatica for node configuration. Also, Informatica is more scalable than Datastage. Datastage is more user-friendly as compared to Informatica.

Q14: Define Routines and their types?
A14: Routines are basically collection of functions that is defined by DS manager. It can be called via transformer stage. There are three types of routines such as, parallel routines, main frame routines and server routines.

Q15: What are the areas of application?
A15: Regardless of your field, DataStage offers you the unique privilege of storing and retrieving your data without any negative impact on your performance.

Q16: What are the benefits of DataStage?
A16: DataStage has three benefits. They are discussed below:

  • Security controls: These offer researchers to have some designated areas for private uses. The researchers and their group leader only can have access to the area. For the benefit of the whole group. There are “collaborative” and “shared” areas where they can put files that are meant for the group.
  • Web interface: This allows annotation of files to the users. They can also access any data from their personal computer at home.
  • Repository: This option is also available for storing data permanently.

Q17: How many areas for files does DataStage have?
A17: DataStage has three storage areas for files. These are:

  • Private: In this storage area, only the owner of a file and the administrator(s) can see the stored files.
  • Shared: All members can see the files. However, they can only read the files without the liberty to amend it. It is read-only access they have.
  • Collaborative: All the members can see a file. They can also edit the contents of a file because they have the right to read and write to the files.

Q18: What are constraints and derivations?
A18: We can create constraints and derivations with datastage variable .

Q19: How do you reject records in a transformer?
A19: Through datastage constraint we can reject record .

Q20: Why do you need stage variables?
A20: That is depend upon job requirement , through stage variable we can file data.

Q21: What is the precedence of stage variables,derivations, and constraints?
A21: stage variables =>constraints=> derivations

Q22: What are data elements?
A22: A specification that describes the type of data in a column and how the data is converted .

Q23: What are routines ?
A23: In Datastage routine is just like function , which we call in datastage job . there are In-Built routine and and also we can create routine .

Q24: What are transforms and what is the differenece between routines and transforms?
A24: Transforms is used to manipulate data within datastage job .

Q25: What a datastage macro?
A25: In datastage macro can be used in expressions , job control routines and before / after subroutines . The available macros are concerned with ascertaining job status .

Q26: What is job control?
A26: A job control routine provides the means of controlling other jobs from the current job. A set of one or more jobs can be validated, run ,reset , stopped , scheduled in much the same way as the current job can be .

Q27: How many types of stage?
A27: There are three basic type of stage

Built-in stages :- Supplied with DataStage and used for extracting , aggregating , transforming , or writing data . All type of job have these stage .

Plug-in stage :- Additional stages that can be installed in DataStage to perform specialized tasks that the built-in stages do not support. Server jobs and parallel jobs can make use of these .

Job Sequence Stages :– Special built-in stages which allow you to define sequences of activities to run. Only job sequencer have these

Q28: What are the types of containers and how to create them?
A28: The containers are of two types namely –

1. Local Container – A particular job is done by the local container
2. Shared Container – The shared container usage can be performed from anywhere within the project.

Creation of Local container:

Step1:Select the stages required
Step2: Select Edit->ConstructContainer->Local

Creation of Shared Container:
Step1:Select the stages required
Step2: Select Edit->ConstructContainer->Shared

Q29: What are the types of hashed files in Data Stage
A29: -Data Stage supports 2 types of hashed files

a) Static – These files are based on Primary Key Pattern and sub divided into 17 types
b) Dynamic – sub divided into 2 types
i) Generic
ii) Specific.

The default hashed file is “Dynamic – Type30”.

Q30: What is DS Administrator used for?
A30: Data Stage users are set up by the Administrator

-Repository purging
-Installation and Managing maps and locales provided, national Language Support is enabled

Q31: What is the difference between In Process and Inter Process?
A31: In-process:

-The performance of Data Stage jobs can be improved by turning in-process row buffering on followed by job recompilation.
-Data from connected active stages is passed through buffers instead of passing row by row.


-Inter process is used when SMP parallel system runs server jobs
-Inter process enables running separate process for every active stage
-Every process will utilize a separate process while running blocks.

Q32: What is difference between server jobs & parallel jobs?
A32: Server Jobs :
-The server jobs are made available once Data Stage Server is installed.
-They are connected to other data sources to meet the necessity demands.

Parallel Jobs:
-Parallel Jobs are available only when Enterprise Edition is installed.
-Parallel jobs run on Data Stage servers which are of SMP,MPP or cluster systems.
-They can run on z/OS systems when needed.

Q33: What are the functionalities of Link Partitioner and Link Collector?
-All the jobs in a server are executed sequentially
– The simulation of parallel mode of execution over other server jobs is done by Partition and Link Collector.
– Data is received by Link Partitioner on a single input link and diverts to a maximum of 64 output links
– Data is Processed by the same stage
– It actually splits data into various partitions or data flows using various partition methods.

Link collector:
– Data from 64 input links is collected by Link Collector and merges into a single data flow
– Link collector loads the collected data to the target.
– All these data stages are active
– The design and execution mode of server jobs are decided by the designer.
– It collects the data coming from partitions, merges it into a single data flow and loads to target.

Datastage Conclusion Interview FAQs

We know the list of Datastage Interview Questions and Answers, Datastage Interview Questions and Answers Freshers, Datastage Interview Questions and Answers, Datastage Interview Questions is overwhelming but the advantages of reading all the questions will maximize your potential and help you crack the interview. The surprising fact is that this Datastage interview questions and answers post covers all the basic of the Datastage technology and you have to check out the FAQs of different components of Datastage too.

However, you will be asked with the questions in the interview related to the above mentioned questions. Preparing and understanding all the concept of Datastage technology will help you strengthen the other little information around the topic.

After preparing these interview questions, we recommend you to go for a mock interview before facing the real one. You can take the help of your friend or a Datastage expert to find the loop holes in your skills and knowledge. Moreover, this will also allow you in practicing and improving the communication skill which plays a vital role in getting placed and grabbing high salaries.

Remember, in the interview, the company or the business or you can say the examiner often checks your basic knowledge of the subject. If your basics is covered and strengthened, you can have the job of your dream. The industry experts understand that if the foundation of the student is already made up, it is easy for the company to educate the employ towards advance skills. If there are no basics, there is no meaning of having learnt the subject.

Therefore, it’s never too late to edge all the basics of any technology. If you think that you’ve not acquired the enough skills, you can join our upcoming batch of Datastage Training in Noida. We are one of the best institute for Datastage in noida which provide advance learning in the field of Datastage Course. We’ve highly qualified professionals working with us and promise top quality education to the students.

We hope that you enjoyed reading Datastage Interview Questions and Answers, Datastage Interview Questions and Answers Freshers, Datastage Interview Questions and Answers, Datastage Interview Questions and all the FAQs associated with the interview. Do not forget to revise all the Datastage interview questions and answers before going for the Datastage interview. In addition to this, if you’ve any doubt or query associated with Datastage, you can contact us anytime. We will be happy to help you out at our earliest convenience. At last, we wish you all the best for your upcoming interview on Datastage Technology.