Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load
Latest Answer : __________________ _______________ ________________|_________________| |______________ ...
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
Using "dsjob" command as follows. dsjob -run -jobstatus projectname jobname
Latest Answer : u can use dsjob executable command from unix or command line.The previous post was correct.Hanu. ...
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 ...
Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there.
Latest Answer : The default cache size is 128 MB. This is primarily used for hash file data cache in the server. This setting is only can be done in Administrator not in job level. Job level tuning is available only for Buffer Size. ...
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 ...
We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External 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]")
Latest Answer : we can achieve this conversion using transformer stage conversion functions in PX.Hanu. ...
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 : Config file was read by datastage engine before running the job in Px.it consist of configuration about your server. ex nodes and all ...
Link Partitioner : It actually splits data into various partitions or data flows using various partition methods . Link Collector : It collects the data coming from partitions, merges it into a single
Latest Answer : server jobs mainly execute the jobs in sequential fashion,the ipc stage as well as link partioner and link collector will simulate the parllel mode of execution over the sever jobs having single cpu Link Partitioner : It receives data on a single input ...