Collection of DataStage Interview Questions.
- Describe iconv and oconv functions?
- What do you mean by project life cycle and how do you implement it?
- Explain the usage of Stage Variable?
- Explain the significance of using the key and difference between Surrogate keys and natural key?
- How to read the data from XL FILES?
- Explain what are Hot Fix for ODBC Stage for AS400 V5R4 in Datastage 7.1?
- What do you mean by a Datastage engine. Explain its purpose and significance
- Differentiate between Transform and Routine in Datastage?
- Why is hash file is faster than sequential file and odbc stage?
- How do you write and execute routines for PX jobs in c++?
- Explain what do you mean by a routine in Datastage?
- How do you distinguish the surrogate key in different dimensional tables?
- Explain how can we generate a surrogate key in server or parallel jobs?
- What do you mean by NLS in Datastage?
- Explain with steps how to read the data from XL FILES?
- What is the difference between pipeline and partition parallelism?
- What is the importance of a Hash file?Can we use sequential file instead?
- Why do we use pivot stage in Datastage?
- Differentiate between reference link and straight link ?
- List the command line functions that import and export the Datastage jobs?
- Name the various process which starts when the Datastage engine starts?
- How to use rank updates strategy in Datastage
- What do you mean by Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
- What do you mean by Runtime Column Propagation and how do we use it?
- Differentiate between OCI stage and ODBC stage?
- Explain how can you remove duplicates without using remove duplicate stage?
- Consider a scenario, if a Datastage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?
- Explain how do we remove duplicates in server job?
- Differentiate between Join, Merge and Lookup Stage?
- Explain how do you run the job in command prompt in unix?
Related Posts
No comments :