1) Define Data Stage? A data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in. Datastage best practices, FAQ, tips and tricks and sample solutions with real- world examples. + Data Stage Interview Questions and Answers, Question1: Explain Data Stage? Question2: Tell how a source file is populated? Question3: Write the.

Author: Mezigrel Moogular
Country: Georgia
Language: English (Spanish)
Genre: Relationship
Published (Last): 7 March 2008
Pages: 302
PDF File Size: 11.57 Mb
ePub File Size: 20.56 Mb
ISBN: 423-1-58438-277-7
Downloads: 46511
Price: Free* [*Free Regsitration Required]
Uploader: Voodoolmaran

Learn DataStage from experts and boost your career. Transaction size means the number of row written before committing the records in a table. In Datastage, validating a job means, executing a job.

A Table definitions specify the format of the data that you want to use at each stage of a job. Datastage is more easy to use as compared to Informatica.

As the name says, data files contains the data and the descriptor file contains the information about the data in the data files. Hi Venkat, Thanks for your great article, btw I want to ask your permission to refer this article into my personal blog http: Which command is used to execute datastage job from command line prompt?

Use the following procedure to make the change. Easily work with your favorite jobs – You can mark your favorite jobs in the Jobs Dashboard, and have them automatically show up on the welcome page.


The two tables are joined on the basis of Primary key columns in both the tables.

Frequently asked questions about IBM DataStage Flow Designer

In the Datastage, the rejected rows are managed through constraints in transformer. July 17, at Find the answers to frequently asked questions about migration, such as where are the server logs written. Which function is used to convert formats from one format to another. You can update the shutdown port of the server 1 by completing the following steps: Orabulk stage is used to load large amount of data in one target table of Oracle database.

Data Stage Interview Questions & Answers

How to check Datastage internal error descriptions 2. Report Attrition rate dips in corporate India: How to release a lock held by jobs?

Orabulk stage is used to store big amount of data in one target table of Oracle database. Wisdomjobs has interview questions which are exclusively designed for job seekers to assist them in clearing job interviews.

Buffer size set to Kb should be fine, however it’s a good idea to increase the timeout.

After reaching the last partition, the collector starts over. IConv is mostly used to change formats for system to understand. Local Datastage containers can be converted at any time to shared containers in datastage designer by right clicking on the container and selecting ‘Convert to Shared’. Illegal placement of parameter markers The problem appears when a project is moved from one project to another for example when deploying a project from a development environment to production.


A Containers are reusable objects that hold user-defined groupings of stages and links. To get the “a b c d” as a result use the trim function in the following way: Your answers are highlighted below. What is a command to analyze hashed file?

In the Datastage, the discarded rows are managed by constraints in transformer. The fields used to define record order are called collecting keys. DataStage has user friendly graphical frontend to design jobs. There is a whole bunch of unix scripts and applications to send sms messages. A InfoSphere Information Server is capable of scaling to meet any information volume requirement so that companies can deliver business results faster and with higher quality results.

Basis on this hash key feature, searching in Hash file is faster than in sequential file.

Top 60 DataStage Interview Questions And Answers [UPDATED]

Normal lookup and Sparse lookup. In the properties file, update the property com. We can call a routine from the transformer stage in Datastage job.