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

How can you do incremental load in Datastage?

 

How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? Explain briefly?

 

What is APT_CONFIG in Datastage

 

How do we do the automation of dsjobs?
 

 

What is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while running any job?
 

 

What is Datastage Multi-byte, Single-byte file conversions?how we use that conversions in Datastage?
 

 

Explain other Performance tunings to increase the performance of slowly running jobs?
 

 

What is Datastage Multi-byte, Single-byte file conversions in Mainframe jobs? what is UTF 8 ? whats use of UTF 8 ?
 

 

What Happens if RCP is disable ?
 

 

What are Routines and where/how are they written and have you written any routines before?
 

 

What is version Control?
 

 

What are the Repository Tables in Datastage and What are they?
 

 

I want to process 3 files in sequentially one by one , how can i do that. while processing the files it should fetch files automatically .
 

 

Where does UNIX script of Datastage executes weather in client machine or in server. suppose if it executes on server then it will execute?
 

 

Please list out the versions of Datastage Parallel , server editions and in which year they are released.
 

 

What are the Job parameters?
 

 

How can I connect my DB2 database on AS400 to Datastage? Do I need to use ODBC 1st to open the database connectivity and then use an adapter for just
 

 

connecting between the two?
 

 

What is difference between serverjobs & paraller jobs
 

 

What is the difference between Datastage and Datastage TX?
 

 

How do we extract data from more than 1 heterogeneous Sources.mean, example 1 sequenal file, Sybase , Oracle in a singale Job.
 

 

How can we improve the performance of Datastage jobs?
 

 

What are the defaults nodes for Datastage parallel Edition
 

 

Explain Orchestrate Vs Datastage Parallel Extender?
 

 

How can we join one Oracle source and Sequential file?.
 

 

What is Modulus and Splitting in Dynamic Hashed File?
 

 

What is the Batch Program and how can generate?
 

 

What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this.
 

 

Could you please help me with a set of questions on Parallel Extender?
 

 

What is difference between Datastage and Informatica
 

 

Suppose if there are million records did you use OCI? If not then what stage do you prefer?
 

 

What are types of Hashed File?
 

 

How do you eliminate duplicate rows?
 

 

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

 

How would call an external Java function which are not supported by Datastage?
 

 

Why do we have to load the dimensional tables first, then fact tables:
 

 

How to create batches in Datastage from command prompt?

Tags