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. 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. Primary Key is a combination of unique and not null. DSWait For File Checks if a BASIC routine is cataloged, either in VOC as a callable item, or in the catalog space. (Oconv) ________________________________________ DATASTAGE FAQ from GEEK INTERVIEW QUESTIONS ________________________________________ Question: Dimension Modeling types along with their significance Answer: Data Modelling is broadly classified into 2 types. Most importance of using it is, it is independent of underlying database, i.e. 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. DSLog Fatal Log an information message in a job's log file. s parameters DSGet Param Info Get the log event from the job log DSGet Log Entry Get a number of log events on the specified subject from the job log DSGet Log Summary Get the newest log event, of a specified type, from the job log DSGet Newest Log Id Log an event to the job log of a different job DSLog Event Stop a controlled job DSStop Job Return a job handle previously obtained from DSAttach Job DSDetach Job Log a fatal error message in a job's log file and aborts the job. 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?
De-generative Dimension: It is line item-oriented fact table design. Stage variables are declaratives in Transformer Stage used to store values. ME token as the Job Handle and can be used in all active stages and before/after subroutines. These are created separately and are stored in the Repository in the same way that jobs are.
*Filter candidates using Test Your and save 80% time ( saving time for recruiters and interviewers) *More than 50% candidates can be filtered on Candidate Screening online tests *Inbuilt exams are available in library, created and tested by experts Try Today... Answer: Parallel Processing is broadly classified into 2 types. Question: What is Modulus and Splitting in Dynamic Hashed File? Question: Have you ever involved in updating the DS versions like DS 5.
DATASTAGE Frequently asked Questions and Tutorials: 1. Answer: In a Hashed File, the size of the file keeps changing randomly. The often Parameterized variables in a job are: DB DSN name, username, password, dates W. X, if so tell us some the steps you have taken in doing so? The following are some of the steps: Definitely take a back up of the whole project(s) by exporting the project as a file See that you are using the same parent folder for the new version also for your old jobs using the hard-coded file path to work.
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?
DSSend Mail Log a warning message to a job log file.
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) ?