What are the components of datastage?
What are the differences between datastage and informatica?
Explain the importance of surrogate key in data warehousing?
How to implement complex jobs in data stage?
Difference between server jobs & parallel jobs?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the functionalities of link collector?
What is the purpose of pivot stage?
When do we analyze the tables?
What is full load & incremental or refresh load?
What is tracing level?
what is a worklet?
When do we analyze the tables? How do we do it?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is etl process? How many steps etl contains?