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) ?
(Schedule can be done daily, weekly, monthly, quarterly) We can monitor the jobs. The available macros are: DSHost Name DSProject Name DSJob Status DSJob Name DSJob Controller DSJob Start Date DSJob Start Time DSJob Start Timestamp DSJob Wave No DSJob Invocations DSJob Invocation Id DSStage Name DSStage Last Err DSStage Type DSStage In Row Num DSStage Var List DSLink Row Count DSLink Last Err DSLink Name 1) Examples 2) To obtain the name of the current job: 3) My Name = DSJob Name To obtain the full current stage name: My Name = DSJob Name : ? : DSStage Name Q 37 What is key Mgt Get Next Value? You can also use shared containers as a way of incorporating server job functionality into parallel jobs. A local container is edited in a tabbed page of the job? Some functions have 0 arguments; most have 1 or more.
The macros provide the functionality for all the possible Info Type arguments for the DSGet? See the Function call help topics for more details. Containers enable you to simplify and modularize your server job designs by replacing complex areas of the diagram with a single container stage. These are created within a job and are only accessible by that job. There are two types of shared container Q 41 What is function? Examples of Transform Functions ) Functions take arguments and return a value. BASIC functions: A function performs mathematical or string manipulations on the arguments supplied to it, and return a value.
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.
Data Stage Manager: We can view and edit the Meta data Repository. We can export the Data stage components in or format. s properties and allows other jobs to be run and controlled from the first job. Specify the job you want to control DSAttach Job Set parameters for the job you want to control DSSet Param Set limits for the job you want to control DSSet Job Limit Request that a job is run DSRun Job Wait for a called job to finish DSWait For Job Gets the meta data details for the specified link DSGet Link Meta Data Get information about the current project DSGet Project Info Get buffer size and timeout value for an IPC or Web Service stage DSGet IPCStage Props Get information about the controlled job or current job DSGet Job Info Get information about the meta bag properties associated with the named job DSGet Job Meta Bag Get information about a stage in the controlled job or current job DSGet Stage Info Get the names of the links attached to the specified stage DSGet Stage Links Get a list of stages of a particular type in a job.
We can declare stage variable in transform, we can call routines, transform, macros, functions. Its input type is literal string & output type is string. Active stages model the flow of data and provide mechanisms for combining data streams, aggregating data, and converting data from one data type to another. Data Stage BASIC functions: These functions can be used in a job control routine, which is defined as part of a 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?
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.
Contains set of properties We can set the buffer size (by default 128 MB) We can increase the buffer size. In tunable we have in process and inter-process In-process? DSGet Stage Types Get information about a link in a controlled job or current job DSGet Link Info Get information about a controlled job? How frequently and from where you get the data as source? What is difference between data mart and data warehouse?