Data Warehouse Interview Questions,Live DataStage Tool Interview Questions.

What are Static Hash files and Dynamic Hash files?

What is the difference between Datastage Server jobs and Datastage Parallel jobs?

What is ' insert for update ' in Datastage

What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?

How will you call external function or subroutine from Datastage?

What happens if the job fails at night?

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

How do you do oracle 4 way inner join if there are 4 oracle input files?

How do you pass filename as the parameter for a job?

How do you populate source files?

How to install and configure Datastage EE on Sun Micro systems multi-processor hardware running the Solaris 9 operating system?

What are all the third party tools used in Datastage?

How do you eliminate duplicate rows?

What is the difference between routine and transform and function?

Do you know about INTEGRITY/QUALITY stage?

How to 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 differences between Oracle8i/9i?

How will you pass the parameter to the job schedule if the job is running at night? What happens if one job fails in the night?

What is an environment variable?

What are the difficulties faced in using Datastage ? or what are the constraints in using Datastage ?

What are XML files and how do you read data from XML files and what stage to be used?

How do you track performance statistics and enhance it?

What are the Types of vies in Datastage Director?

How do you pass the parameter to the job sequence if the job is running at night?

Explain a specific scenario where we would use range partitioning ?

What is job commit in Datastage?

What is the main disadvantages of staging area

How do you configure api_dump

Does type of partitioning change for SMP and MPP systems?

What is the difference between RELEASE THE JOB and KILL THE JOB?

Can you convert a snow flake schema into star schema?

What is repository?

What is Fact loading, how to do it?

What is the alternative way where we can do job control?

Where we can use these Stages Link Partitionar, Link Collector & Inter Process (OCI)

Where can you output data using the Peek Stage?

Do you know about METASTAGE?

In which situation, we are using RUN TIME COLUMN PROPAGATION option?

What is the difference between Datastage and Datastage TX?

Difference between Hashfile and Sequential File?.

What is modulus?

What is iconv and oconv functions?