![]() 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 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. ... 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. ... 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 : 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. ... There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Latest Answer : From what I know there are four views1> Status 2> Schedule3> Log4> Detail. ... What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ? Latest Answer : U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecDOSor By using Command Stage Plug-In or by calling the routine from external command activity from Job Sequence. ... Give the OS of the Server and the OS of the Client of your recent most project Latest Answer : server is unix and client machine i.e is ur machine where u design a job is windows xp professional ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||