DataStage interview questions for freshers and experienced.
Please use the comment section to answer the Datastage Interview Questions.
- Define Static Hash files and Dynamic Hash files?
- Differentiate between Datastage Server jobs and Datastage Parallel jobs?
- Explain what is 'insert for update' in Datastage
- How can you call external function or subroutine from Datastage?
- How can you do oracle 4 way inner join if there are 4 oracle input files?
- How can you pass filename as the parameter for a job in Datastage?
- Explain the process of populating source files?
- Explain the process of installing and configuring Datastage EE on Sun Micro systems multi-processor hardware running the Solaris 9 operating system?
- Explain the process of eliminating duplicate rows?
- Differentiate between routine and transform and function?
- What do you know about INTEGRITY/QUALITY stage?
- How do you attach a mtr file (MapTrace) via email and the MapTrace is used to record all the execute map errors?
- If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does Datastage create?
- Explain the main differences between Oracle8i and 9i database?
- Explain how will you pass the parameter to the job schedule if the job is running at night? What step will you take if the job fails at night?
- Explain what are the difficulties and constraints faced in using Datastage ?
- What are XML files and how do you read data from XML files and what stage to be used?
- How will you track performance statistics and enhance it in Datastage?
- How will you pass the parameter to the job sequence if the job is running at night?
- Explain with a scenario where we would use range partitioning ?
- What do you mean by job commit in Datastage?
- Explain what is the main disadvantages of staging area ?
- How will you configure api_dump in Datastage?
- Does type of partitioning change for SMP and MPP systems?
- What is the main difference between RELEASE THE JOB and KILL THE JOB?
- How can you convert a snow flake schema into star schema. Explain?
- What do you mean by Fact loading?
- Where we can use these Stages Link Partitionar, Link Collector and Inter Process (OCI) in Datastage?
- Where can you output data using the Peek Stage?
- Define METASTAGE?
- In which situation, we are using RUN TIME COLUMN PROPAGATION option?
- Explain what is the difference between Datastage and Datastage TX?
Related Posts
No comments :