Row cannot be located for updating mysql server
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.
DSPrepare Job Interface to system send mail facility.
(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) ?
(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.
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. 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. 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. 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? Package Installer Data Stage Administrator: Used to create the project. We can create routines and transforms We can compile the multiple jobs. Some of the functions can also be used for getting status information on the current job; these are useful in active stage expressions and before- and after-stage subroutines. DSGet Stages Of Type Get information about the types of stage in a job.
*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.