DataStage Interview Questions For Experienced

What are the main features of datastage? DataStage has the following features to aid the design and processing required to build a data warehouse : - Uses graphical design tools. With simple point and click techniques you can draw a scheme to represent your processing requirements. - Extracts data from any number or types of database. - Handles all the metadata definitions required to define your data warehouse. - You can view and modify the table definitions at any point during the design of your application. - Aggregates data. - You can modify SQL SELECT statements used to extract data. - Transforms data. DataStage has a set of predefined transforms and functions. you can use to convert your data. You can easily extend the functionality by defining your own transforms to use. - Loads the data warehouse. What are Stage Variables, Derivations, and Constants? Stage Variable: An intermediate processing variable that retains value during read and doesn’t pass the value into target column. Derivation: Expression that specifies value to be passed on to the target column. Constant: Conditions that are either true or false that specifies flow of data with a link. Read More Click here: https://tekslate.com/datastage-interview-questions-answers