DataStage Interview Questions asked in a Datawarehousing Interview.
- Can you tell me is it possible to run parallel jobs in server jobs?
- Explain what are the enhancements made in Datastage 7.5 compared to 7.0?
- If you add a new environment variable in Windows, how can I access it in Datastage?
- Can you tell if it possible to move the data from oracle ware house to SAP Warehouse using with Datastage Tool.
- Explain in brief how can we create Containers?
- What do you mean by a data set? What is a file set?
- Differentiate between Inprocess and Interprocess ?
- Briefly describe about the various client components?
- Describe orabulk and bcp stages in Datastage?
- What is the use of DS Director?
- How do you extract data from DB2 (on IBM iSeries) to the data warehouse using Datastage as the ETL tool.
- Can you tell me how can we pass parameters to a job by using file?
- How can we implement Lookup in Datastage Server jobs?
- What is the user variable activity, tell me when it used and how it used? Explain with examples.
- What do you mean by hashing algorithm and explain in brief how it works?
- Explain what happens when output of a hash file is connected to transformer.
- What is merge operation and how to use merge in Datastage?
- Under what circumstances you use SQL LOADER or OCI STAGE?
- What are the main use of System variables?
- Can you tell me how the hash file does lookup in server jobs? How does it compare the key values?
- How do you handle the rejected rows in Datastage?
- Explain how is Datastage 4.0 functionally different from the enterprise edition now? Describe the exact changes?
- How can you specify a filter command for processing data while defining sequential file output data?
- Name the three different types of user-created stages available for PX?
- Does Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only?
- Explain what are the validations you would perform after creating jobs in designer?
- Describe the different type of errors you faced during loading and what approach you applied to solve them.
- Explain what you mean by merge and how it can be done. Can you explain with an example taking two tables?
Related Posts
No comments :