DataStage DataWarehousing Interview Questions.
Learn by sharing DataStage Interview Questions asked in various companies.
- Explain in detail how would you check for Job Errors in Datastage?
- Define Stage Variables and Derivations and Constants?
- What do you mean by Pipeline Parallelism?
- What is the version of Datastage you used ion your project and what are the features?
- Can you tell me why do we use a transformer?
- Explain about different schemas you have used in your Datastage project ?
- What was the intention of choosing one schema over another ?
- How can you read a sequential file in parallel?
- Explain different types of containers ?
- In a Datastage project where would you use the containers?
- Describe the whole process of updating the process control tables ?
- How do you implement SCD type I ,II, III in Datastage? Describe the diagram of jobs?
- How do you invoke a query in Datastage jobs ?
- Explain about environmental variables and the ways to declare them ?
- How do you invoke a bteq script in Datastage?
- Describe different ways to control the execution of Datastage jobs
- Explain what is the difference between Merge Stage and Lookup Stage?
- Differentiate between the Dynamic RDBMS Stage and Static RDBMS Stage ?
- How can you maintain version of Datastage jobs in a project?
- Explain how can you give access to multiple users for a job?
- How can you remove warnings in Datastage jobs ?
- Elaborate the process of removing duplicates ?
- Define server jobs in Datastage?
- What do you mean by containers?
- Is it possible to access the same job two users at a time in Datastage?
- Tell us the possible ways of improving performance in aggregator stage?
- Describe SQL tuning in Datastage? Explain the process?
- Explain what is the use of tunnable?
- How do you distinguish the surrogate key in different dimensional tables? How can we give for different dimension tables?
- How do you load source into ODS in Datastage?
- Can you tell me howow to kill the job in Datastage?
- How do you find the process id? Can you elaborate with steps?
- Explain what is Integrated and Unit testing in Datastage ?
Related Posts
No comments :