Download Remote Manuals
What is the difference between IBM Web Sphere Datastage 7.5 (Enterprise Edition ) & Standard Ascential?
How do you remove duplicates in dataset
The Join stage does not provide reject handling for unmatched records (such as in an InnerJoin scenario). If un-matched rows must be captured or logged, an OUTER join operation must be performed.
What versions of DS you worked with?
Ans: DS 7.0.2/6.0/5.2
DataStage EE provides a number of environment variables to control how jobs operate on a UNIX system. In addition to providing required information, environment variables can be used
What is the importance of Surrogate Key in Data warehousing?
How did you handle reject data?
The parallel Transformer stage always generates “C” code which is then compiled to a parallel component.
Data Warehouse Interview Questions,Live DataStage Tool Interview Questions.
What are Static Hash files and Dynamic Hash files?
The Lookup stage is most appropriate when the reference data for all lookup stages in a job is small enough to fit into available physical memory. Each lookup reference requires a contiguous block of physical memory.
How do we create index in Datasatge?
What is the flow of loading data into fact & dimensional tables?
What is a sequential file that has single input link?