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. ...
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. ...
Create a Excel spreadsheet with new and old names. Export the whole project as a dsx. Write a Perl program, which can do a simple rename of the strings looking up the Excel file. Then import the new dsx
DWH's are typically read only, batch updated on a scheduleODS's are maintained in more real time, trickle fed constantly
Batch programe is the programe it's generate run time to maintain by the datastage it self but u can easy to change own the basis of your requirement (Extraction, Transformation,Loading) .Batch programe
1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improve
Latest Answer : You can also generate the surrogate key in the database using the sequence generator. ...
Latest Answer : DSJOB Command is the command to run the datastage jobs from command line . in the older architectures people use to create the Batchjob to control the remaining datastage jobs in the process in KEN BLEND arch. With DSJob command you can run any datastage ...
A batch is running and it is scheduled to run in 5 minutes. But after 10 days the time changes to 10 minutes. What type of error is this and how to fix it?