DataStage Interview Questions and Answers,Solution and Explanation - Part 8

What is merge and how it can be done Please explain with simple example taking 2 tables?

Is it possible to run parallel jobs in server jobs?

What are the enhancements made in Datastage 7.5 compare with 7.0

If I add a new environment variable in Windows, how can I access it in Datastage?

What is OCI?

Is it possible to move the data from oracle ware house to SAP Warehouse using with Datastage Tool.

How can we create Containers?

What is data set? and what is file set?

How much would be the size of the database in Datastage ?What is the difference between Inprocess and Interprocess ?

Briefly describe the various client components?

What are orabulk and bcp stages?

What is DS Director used for?

How can I extract data from DB2 (on IBM iSeries) to the data warehouse via Datastage
as the ETL tool.

Is it possible to call one job in another job in server jobs?

How can we pass parameters to job by using file.

How can we implement Lookup in Datastage Server jobs?

What user variable activity when it used how it used !where it is used with real example

What is hashing algorithm and explain briefly how it works?

What happens out put of hash file is connected to transformer

What is merge and how to use merge?

What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.

What is the NLS equivalent to NLS oracle code American_America.US7ASCII on Datastage NLS?

Why do you use SQL LOADER or OCI STAGE?

What about System variables?

What are the differences between the Datastage 7.0 and 7.5in server jobs?

How the hash file is doing lookup in serverjobs?How is it comparing the key values?

How to handle the rejected rows in Datastage?

How is Datastage 4.0 functionally different from the enterprise edition now? what are the exact changes?

If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?

How can I specify a filter command for processing data while defining sequential file output data?

There are three different types of user-created stages available for PX. What are they?

Which would you use? What are the disadvantage for using each type?

What is DS Manager used for - did you use it?

Does Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only?

What are validations you perform after creating jobs in designer.

What are the different type of errors you faced during loading and how you solve them

Tags