DataStage Frequently asked Interview Questions in various companies.
- Explain how do we create index in Datasatge?
- Describe the whole flow of loading data into fact and dimensional tables?
- What is a sequential file that has single input link?
- Explain hashing algorithm in Datastage?
- What is Orchestrate options in generic stage, what are the option names value ?
- What are the steps you would take to fix the error "OCI has fetched truncated data" in Datastage?
- A batch process is running and it is scheduled to run in 5 minutes. After 10 days the time changes to 15 minutes. What type of error is this and how are the steps you would take to fix it?
- What is the partition you have to use for Aggregate Stage in parallel jobs ?
- What is the baseline to implement partition or parallel execution method in Datastage job. For instance. more than 2 millions records only advised ?
- What are the orchestrate operators available in Datastage for AIX environment.
- Explain about the Debug stages in PX.
- Differentiate between Sequential Stage and Dataset Stage. When and how do you use them.?
- Explain how is memory allocation done while using lookup stage
- Describe about the Phantom error in the Datastage . How do you overcome this error?
- Explain about the Parameter file usage in Datastage
- Are Type 30D hash file is GENERIC or SPECIFIC?
- Is Hashed file an Active or Passive Stage? When and how will be it useful?
- Explain h0w do you extract job parameters from a file in DataStage?
- What are System variables.When are they used?
- How do we create Containers?
- How do we tune the performance of Datastage?
- What are the Job parameters that you use in DataStage?
- Differentiate between routine and transform and function?
- Explain how do we implement Lookup in Datastage Server jobs?
- How do we implement Slowly Changing Dimensions in Datastage?.
- How do we join one Oracle source and Sequential file?.
- What do you mean by iconv and oconv functions?
- Define quality stage and profile stage?
- What is the use, significance and advantage of procedure in Datastage?
- What are the important considerations while using join stage instead of lookups.
- Explain how do you implement the type 2 Slowly Changing dimension in Datastage?
- Name some the third party tools used in Datastage?
Related Posts
No comments :