DSPrepare Job Interface to system send mail facility.
Question: How to handle Date convertions in Datastage? Answer: We use a) "Iconv" function - Internal Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") Question: Types of Parallel Processing? Question: What does a Config File in parallel extender consist of? Link Collector: It collects the data coming from partitions, merges it into a single data flow and loads to target.
Answer: ODBC PLUG-IN Poor Performance Good Performance Can be used for Variety of Databases Database Specific (only one database) Can handle Stored Procedures Cannot handle Stored Procedures Question: How do you execute datastage job from command line prompt? dsjob -run -jobstatus projectname jobname Question: What are the command line functions that import and export the DS jobs? Answer: IConv() - Converts a string to an internal storage format OConv() - Converts an expression to an output format. Answer: Link Partitioner: It actually splits data into various partitions or data flows using various Partition methods.
A) Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table. Answer: Primary Key is a combination of unique and not null.
SET_JOB_PARAMETERS_ROUTINE ________________________________________ DATASTAGE QUESTIONS ________________________________________ 1. What is the flow of loading data into fact & dimensional tables? Load - Data should be first loaded into dimensional table. Now Datastage has purchased Orchestrate and integrated it with Datastage XE and released a new version Datastage 6.0 i.e. Question: Differentiate Primary Key and Partition Key?
Answer: Stage Variable - An intermediate processing variable that retains value during read and doesn? Constraint - Conditions that are either true or false that specifies flow of data with a link. Question: What is Hash file stage and what is it used for? A) Static - Sub divided into 17 types based on Primary Key Pattern. Question: How to run a Shell Script within the scope of a Data stage job?