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

What are the Environmental variables in Datastage?

How do you check for Job Errors in Datastage

What are Stage Variables, Derivations and Constants?

What is Pipeline Parallelism?

Which version of Datastage did you use and what are the features in it?

Why do we use a transformer?

What are different schemas you have used in your project ?

What was the intention of choosing one schema over another ?

How do you read a sequential file parallely ?

What are the different types of errors you have encountered and how did you troubleshoot them or what work around you found for them ?

What are different types of containers ?

In a project where did you use the containers?

Tell me the whole process of updating the process control tables ?

How do you implement SCD type I ,II, III in Datastage? Write the diagram of jobs?

How do you invoke a query in Datastage jobs ?

What are environmental variables? How do you declare them ?
How can you invoke a bteq script in Datastage?

What are the different ways to control the execution of Datastage jobs

What is the difference between Merge Stage and Lookup Stage?

What is the difference between the Dynamic RDBMS Stage & Static RDBMS Stage ?

How do you maintain version of Datastage jobs in a project?

How do you give access to multiple users for a job?

How do you remove warnings in Datastage jobs ?

How do you remove duplicates ?

What is the difference between Datastage and Informatica ?

What are server jobs ?

What are containers ?

Tags