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: Minris Kazrabei
Country: Suriname
Language: English (Spanish)
Genre: Spiritual
Published (Last): 16 September 2012
Pages: 307
PDF File Size: 12.67 Mb
ePub File Size: 1.53 Mb
ISBN: 151-2-76722-494-7
Downloads: 42298
Price: Free* [*Free Regsitration Required]
Uploader: Zulujora

If you leave this page, your progress will be lost. Consider splitting it into two or three smaller jobs, review fetches and lookups and try to optimize them especially have a look at the SQL statements.

Oracle 11g Interview Questions. Can the server be stopped by using a browser? There is a whole bunch of unix scripts and applications to send sms messages.

DataStage Interview Questions And Answers

Then select Inter process which will let the link collector run correctly. A Dqtastage partitioning is an approach to parallelism that involves breaking the records into partitions, or subsets of records. Therefore, the Sparse lkp is faster than the Normal lkp.

Such routines are also created in DS manager and can be called from transformer stage. To get rid of error fill in the ‘Procedure name’ field. Your email address will not be published. We can use the palette to drag and drop connectors and operators on to the designer canvas. A InfoSphere DataStage brings the power of parallel processing to the data extraction and transformation process.


If this activity does not load, try refreshing your browser. Last but not the least, we should understand and assess the available tuning knobs. You have not finished your quiz. In datastage, there is a perception of separation, parallelism for node configuration. On the services tier, run the applicable command to update the DataStage Flow Designer server port: Routines are of three types such as, parallel routines, server routines and main frame routines.

Datsstage splitsubrec restructure operator separates input subrecords into sets of output top-level vector fields. Learn more about DataStage in this insightful blog post now.

Fqas is type of view in data stage director? So if you want to delete the first line from the file itself, you have two options. There are three types of routines such as, parallel routines, main frame routines and server routines. How to send notifications from Datastage as a text message sms to a cell phone.


All the stages after the exception activity in Datastage are executed in case of any unknown error occurs while executing the job sequencer. After opening a job sequence and navigating to the job activity properties window the application freezes datastgae the only way to close it is from the Windows Task Manager.

In a totally sorted data set, the records in each partition of the data set, as well as the partitions themselves, are ordered. First compile it and then click ‘Test Connection to CognitiveDesigner Server refused. Hashed files are especially useful if they store information with data dictionaries customer details, countries, exchange rates.

How do you decide which one to use?

Datastage Interview questions with Answers | TestingBrain

This type of job was previously called a job sequence. Links are like pipes through which the data flows from one stage to the next. It uses Index to perform the retrieval operation. Normal lkp and Sparse lkp.