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
By using "ExcecSH" command at Before/After job properties.
Latest Answer : You can specify the ExecDos Prompt in the after or before job routine. ...
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. ...
100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody
Latest Answer : - I don't think these are the right numbers. Someone creating 100+ jobs in 6 months !! If you do the math - it would be 6 Months = 6 months * 22 Days * 8 Hours = 1056 hours. The above statements assume that a job would take equal to or less ...
Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters
Latest Answer : hi please send me some real time questions in datastage for interview.i have interview on sunday for accenturehow do u implement rank in datastage os: windows ...
Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so?
Yes. The following are some of the steps; I have taken in doing so:1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file2) See that you are using the same parent
Yes. One of the most important requirements.
Latest Answer : some times u need to write unix progrms in back round !like batch progms ! bcz data stage can invoke a batch processing in every 24 hrs .soo.......unix must... so that we can run the unix prog in back round even min/ hrs ...
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
Sequencers are job control programs that execute other jobs with preset Job parameters.
Latest Answer : A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It can have multiple input triggers as well as multiple output triggers.The sequencer operates in two modes:ALL mode. In this mode all of the inputs to the ...
What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.
A. Under Windows: Use the 'WaitForFileActivity' under the Sequencers and then run the job. May be you can schedule the sequencer around the time the file is expected to arrive.B. Under