DSXchange

And you cannot expect any stage to drop the columns automatically.

Alright, before proceeding further, take a back of the whole project. Do a unix backup as well. Try to import some of the jobs in other project and check, if that work. If that works, you can try to to a COUNT on the project hash files to ensure that, they were in accsseble state without any error. ...

Thanks Kenneth, I was wondering for the same reason. There is a log in DataStage, which assures that the Cron has executed the job, but job didnt have any further log. Other that that single entry. And started as expected from next day of the schedule. Even for check point restart, atlest the enviro...

Though you can load more than one table in a single job, it is suggested to split it. It is better to have many module. You can optionally group it based on some master tables and its child tables to gether.

It is a file which Datastage will insert the runtime informations. IF the file doesnt present, DataStage will create one, according to the Routine number. If you were sure that, all you routines were not responding recently, check in other projects with the same user id/ diffrent user id. You can gi...

You can parse the exported dsx file. But you can alternativly get these information from DS_JOBS. But when I tried to get Description from DS_JOBS, I get the following error. DataStage/SQL: syntax error. Unexpected symbol. Token was "DESC" Not sure, if we need get it by other means. Hope K...

If you read as date and load as date, there is no external conversino required. If you read as Char or varchar, you can use TO_DATE() in userdefined query, or Oconv/Iconv in datastage.

Right under your project directory.

Do you need help for becomign member, Click on "Premium Membership" from the home page Navigation.
If you need help on you issue, search for "ENV SET".

But there are scenarios where you cannot run the job in the given environment. Additionally, by Validating the job, the required output files will be created with empty content.

The same time, in DW Project, ETL will play considerable role, but ETL alone doesnt make DW.

Hi DSXians, JobSequence is scheduled from datastage scheduler. It used to run daily. The first entry in the log usually be DS.SCHED: Started at: 22:30:02 21 SEP 2006, directory <Project> JobNumber=81, TraceLevel=0/50, JobInstance=2 But last night, this is the only entry available and the job was not...

Is it only from single machnie or from all the clinet pc?
Is it only to single project or to all the 5 projects?
If it is only to single project, you may need to check the integrity of you project files or you may even need to FIX some files.
If its only with one PC, reinstall the client software.

It is the 'Time' datatype which occupies 8Bytes.

Be ready to take up both the option. You need to find the maximum usage of CPU at each instance and schedule the jobs accordingly. You can split up the job, and run it paralley till you reach the CPU usage at prescribed limit. Do think about the number of process running altogether in every node for...