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. ...
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. ...
What are Routines and where/how are they written and have you written any routines before?
Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines: 1) Transform functions
Starting from DS 6.0 we have the ability to call external Java functions using a Java package from Ascential. In this case we can even use the command line to invoke the Java function and write the return
Latest Answer : Use the Java PACK. Java Pack has Java Client and Java Transformer Stages. YOu can write your own class and call it from either from Client or Transformer stages. ...
A. dsimport.exe- imports the DataStage components.B. dsexport.exe- exports the DataStage components.
Latest Answer : Parameters: UserName,Password, Hostname, ProjectName,CurrentDirectory(C:/Ascential/DataStage7.5.1/dsexport.exe),FileName(JobName). ...