Failed updating entry in message tracking store in msgid Online naughty chat rooms no sign up
b) Dynamic - sub divided into 2 types i) Generic ii) Specific. What is Modulus and Splitting in Dynamic Hashed File? In a Hashed File, the size of the file keeps changing randomly. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel processing capabilities. A) Surrogate Key is a Primary Key for a Dimension table. A) We use a) "Iconv" function - Internal Conversion. 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]") 13 How do you execute datastage job from command line prompt? Link Partitioner: It actually splits data into various partitions or data flows using various partition methods. A) Dimensional modeling is again sub divided into 2 types. A) Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. Routines are stored in the Routines branch of the Data Stage Repository, where you can create, view or edit. Answer: Data in a Database is A) Detailed or Transactional B) Both Readable and Writable. Question: What is the flow of loading data into fact & dimensional tables? Load - Data should be first loaded into dimensional table. a) Static - Sub divided into 17 types based on Primary Key Pattern. A) Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Functionality of Link Partitioner and Link Collector? b) Snowflake Schema - Complex with more Granularity. While using Hash partition we specify the Partition Key. Differentiate Database data and Data warehouse data? DSExecute Set a status message for a job to return as a termination message when it finishes DSSet User Status Q 42 What is Routines? Q 47 What are different activities in job sequencer? (conditional, unconditional, otherwise) Q 49 Are u generated job Reports? Question: Differentiate Database data and Data warehouse data? (Only one database) c) Cannot handle Stored Procedures. Dimension Modelling types along with their significance Data Modelling is Broadly classified into 2 types. Data Stage contains two components, Client Component. DSMake Msg Ensure a job is in the correct state to be run or validated.
It is a Built-in transform it generates Sequential numbers. Passive stages handle access to databases for extracting or writing data. Arguments are always in parentheses, separated by commas, as shown in this general syntax: Function Name (argument, argument) ? 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. Answer: As the names itself suggest what they mean. The Data file has a default size of 2GB and the overflow file is used if the data exceeds the 2GB size. Question: Compare and Contrast ODBC and Plug-In stages? Question: What are OConv () and Iconv () functions and where are they used? Question: Functionality of Link Partitioner and Link Collector? Derivation - Expression that specifies value to be passed on to the target column. B) Dynamic - sub divided into 2 types i) Generic ii) Specific Default Hased file is "Dynamic - Type Random 30 D" Question: What are Static Hash files and Dynamic Hash files? Answer: Container is a collection of stages used for the purpose of Reusability. A) Local Container: Job Specific B) Shared Container: Used in any job within a project. Answer: By using "Excec SH" command at Before/After job properties. 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?