Datastage Interview Questions.
Ascential Datastage Interview Questions asked in top companies like IBM, HP, TCS.
- Explain how do we join one Oracle source and Sequential file?
- Can you explain how we can implement Lookup in Datastage Server jobs?
- Differentiate between routine and transform and function?
- Is it possible to query a hash file? Can you justify your answer.
- Explain how do we enable the Datastage Engine?
- How can you convert Server Jobs into Parallel Jobs?
- How do you parameterize a field in a sequential file when you are using Datastage as ETL Tool?
- What do you mean by TX and what is the use of this in Datastage?
- Differentiate between Merge Stage and Lookup Stage.
- Explain what is the difference between symmetrically parallel processing, massively parallel processing?
- Differentiate between the Dynamic RDBMS Stage and Static RDBMS Stage.
- Explain the steps to run a job using command line.
- Explain about user activity in Datastage?
- How can you catch bad rows from OCI stage?
- How do you find duplicate records using transformer stage in server edition?
- What do you mean panthom error in Datastage.Explain?
- How can we increment the surrogate key value for every insert in to target database?
- Why do we use environmental variables?
- What do you mean by fact load?
- How can we improve the job performance in Datastage?
- How we can create rank using Datastage like in Informatica?
- What is the use of job control?
- What does # indicate in environment variables?
- What are two different types of hash files?
- Describe different types of star schema?
- What are different types of file formats available?
- Name the different dimension table in a project? Describe with an example?
- Explain what is the difference between buildopts and subroutines ?
- Differentiate between sequential file and a dataset? When to use the copy stage?
- Explain the process of eliminating duplicate rows in Datastage?
- What do you mean by complex stage? In which situation do we use one?
- What do you mean by sequencer stage?
- Describe different types of lookups in Datastage?
- How do you find errors in job sequence?
- Explain the process of implementing Slowly Changing Dimensions in Datastage?
Related Posts
No comments :