XXX Chats

twista dating pinky

Failed updating entry in message tracking store in msgid

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?

What does a Config File in parallel extender consist of? Constant - Conditions that are either true or false that specifies flow of data with a link. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel processing capabilities.

DSSend Mail Log a warning message to a job log file.

DSPrepare Job Interface to system send mail facility.

When creating a dynamic file you can specify the following Although all of these have default values) By Default Hashed file is "Dynamic - Type Random 30 D" 4. If the size of the file decreases it is called as "Splitting". What are Stage Variables, Derivations and Constants? Stage Variable - An intermediate processing variable that retains value during read and doesn? Derivation - Expression that specifies value to be passed on to the target column. There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. A) Parallel Processing is broadly classified into 2 types. A) By using "Excec SH" command at Before/After job properties. Question: Orchestrate Vs Datastage Parallel Extender? Answer: Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform.

We can increase it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. Dynamic files do not perform as well as a well, designed static file, but do perform better than a badly designed one. If the size of the file increases it is called as "Modulus". Now Datastage has purchased Orchestrate and integrated it with Datastage XE and released a new version Datastage 6.0 i.e Parallel Extender. Most importance of using it is it is independent of underlying database. Surrogate Key is not affected by the changes going on with a database. How to run a Shell Script within the scope of a Data stage job? Link Collector: It collects the data coming from partitions, merges it into a single data flow and loads to target. The following programming components are classified as routines: Transform functions, Before/After subroutines, Custom Uni Verse functions, Active X (OLE) functions, Web Service routines Q 43 What is data stage Transform? Answer: 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, then data should be loaded into Fact table.

Question: What are Stage Variables, Derivations and Constants? We can increase it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. It is also used in-place of ODBC, OCI tables for better performance. Answer: Hashed File is classified broadly into 2 types.

While using Hash partition we specify the Partition Key. DSTranslate Code Suspend a job until a named file either exists or does not exist. Question: Dimensional modelling is again sub divided into 2 types. Answer: Surrogate Key is a Primary Key for a Dimension table. DSTransform Error Convert a job control status or error code into an explanatory text message. B) Snowflake Schema - Complex with more Granularity. Question: Importance of Surrogate Key in Data warehousing? It can be a collection of key values called as composite primary key. There are several methods of partition like Hash, DB2, Random etc... 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. 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? 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. Q 21 What are Ascential Dastastage Products, Connectivity Ans: Ascential Products Ascential Data Stage Ascential Data Stage EE (3) Ascential Data Stage EE MVS Ascential Data Stage TX Ascential Quality Stage Ascential Meta Stage Ascential RTI (2) Ascential Profile Stage Ascential Audit Stage Ascential Commerce Manager Industry Solutions Connectivity Files RDBMS Real-time PACKs EDI Other Q 22 Explain Data Stage Architecture? DSMake Job Report Insert arguments into the message template.

Comments Failed updating entry in message tracking store in msgid