 Related Questions Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the parallel Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target Latest Answer : all r correct one only ... Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. Latest Answer : Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. · There are two types of shared container:· 1.Server shared ... ODBC : a) Poor Performance. b) Can be used for Variety of Databases. c) Can handle Stored Procedures. Plug-In: a) Good Performance. b) Database specific.(Only one database) c) Cannot handle Stored Procedures. Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing. Latest Answer : Hardware wise there are 3 types of parallel processing systems available:1. SMP (symetric multiprocessing: multiple CPUs, shared memory, single OS)2. MPP (Massively Parallel Processing Systems: multiple CPUs each having a personal set of resources - ... Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location. Latest Answer : Biggest strength of Datastage PX is its configuration file.. Datastage engine learns about size and shape of the system by reading configuration file.It contains Nodes and resource available for running the job. ... Latest Answer : Partition the table if there is huge data. This will enhance performance statistics. ... A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort. Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance. Latest Answer : We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a particular fileld ... What are other Performance tunings you have done in your last project to increase the performance of What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs? Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performance also for data recovery in case job aborts.Tuned the OCI stage for 'Array
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
