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
Latest Answer : If you export the jobs in an XML file you can easily do a find and replace for anything using notepad. So if the standard for master is changed from mst to mstr you simply for a find and replace. Or if the jobs are jobnam_dev you and you need to ...
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 generate through system variable in transformer which is built-in name is keymgt. You don't have remember full name and in parallel you can generate through surrogate key 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?
What is meant by real-time integration in terms of datastage and how is different from the same in Informatica.Explain batch and real time processing capabilities of both ETL tools with their characteristic
