Concatenating field field oracle third two updating Online boy sex chat
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.
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?
If you need to connect to multiple tables in the same data connection, then you’ll need to use a Stored Procedure or an Query.
Note that the “first”, “previous”, “next” and “last” statements imply an “update” by default which means that if you simply use to move to the next record and the user has made changes to the current record, those changes will be committed prior to moving to the next record.
If you pick a table with an auto-increment column, you’ll be able to read from it but you’ll get errors when you try to push data into it.
If this is the case, write an Query that selects all columns in the table except for those which are auto-incremented.
It can be a collection of key values called as composite primary key. There are several methods of partition like Hash, DB2, and Random etc. 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. DSCheck Routine Execute a DOS or Data Stage Engine command from a before/after subroutine. Surrogate Key is not affected by the changes going on with a database.
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.
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.