DSXchange

Store the o/p of xfmA in some temp file (which includes the value of xfmA Stage var), read it along with xfmA Stage var in xfmB. - Sachin Thanks Ray , Sachin: I was trying to assign a job variable in transformerA and use it in another transformerB which is not downstream to this stage. But I am sure...

You can't. Stage variable stays in the Stage.

Ray's method is a good way. You can concatenate (with ":") any other value to it and propogate it downstream too.

- Sachin

Not sure if Ascential gives any certification on their products yet. Please some one correct me if I am wrong (apart from Mercator\TX may be). - Sachin Hi, Can anyone let me know the best way to get trained in Ascential DataStage Enterprise Edition. I have looked at Ascentials course, looks good but...

DataStage PX is designed more from ETL point of view, while TX is mainly for converting data. Although, TX has interfaces setup for various systems, it cannot take care of data partitioning as effeciently as in PX, and not sure if TX can take care of bulk loads into databases too. PX is designed to ...

Its in the documentation. But It can also return the output of your script program that ran, so don't get confused with that. - Sachin When I make a Mercator cmd line call in unix I get back various return codes depending upon the error - does anybody have a map of Error Codes to Error Descriptions?

Yes. Depending on your OS, a run pofile script will be needed to do this.

- Sachin

netboyks wrote:Hi All,
We are in the process of installing QS. I want to know if we can call QS jobs via autosys without a datastage job.
Thanks
Netboyks

You can use dsjob from OS console to do a RESET of the jobs so that they are in runnable state, but I'm not sure about compiling them from OS (without writing heavy code). Haven't done that through a routine yet, so can't answer that one for you. - Sachin How can we do to compile all jobs ( i have s...

Have them read from read-only file (permission to read by PROD usr group) - Sachin Hi all, I would like to know , how can i make project environment variables encrypted like such as oracle password and use them as finally job parameters. i mean project environment variable used as job parameters. Ca...

1. Read it as varchar 2. Use the transformer to parse the numeric value\ validate it as you want 3. Send the output link to be processed to your "real" ETL 4. Read the BASIC pdf file that came with DataStage installation to help you with the routines\conditional statements Or search the DS...

I think someone will definately need atleast the field in the database table to which the column (85th or 95th) will go to, to figure out how to read the inbound data. May be you can try to see how they were fetching all the columns in their fields before they got DataStage and probably try to use t...

peace :) Roy, The problem is reliability, and the production support. Not all production support guys will know DataStage, but many will feel comfortable with the OS commands. Ofcourse, the DataStage consultant is expected to go in and out of DataStage judiciously while creating ETL. I'm talking abo...

Roy, The problem is reliability, and the production support. Not all production support guys will know DataStage, but many will feel comfortable with the OS commands. Ofcourse, the DataStage consultant is expected to go in and out of DataStage judiciously while creating ETL. I'm talking about the ra...

DS should be used to make things easy and streamlined that you cannot otherwise. If using DS will make it more complex, try not to use it, unless your boss insists. I would go for OS level ftp, as its reliable, efficient and easy to use and change. I've not used FTPStage myself though, so I'm sorry ...

Why don't you write a shell script to get this done? Why unnecessarily have an additional DataStage layer. Get a cronjob to run teh script every 4 hours. Move the files (based on any criteria that you might have) to another directory from where DS can fetch it. Move the rest of the files (if any) to...

You might be confusing it with the ETL version. They are two different species sent to this earth by the same Ascential (now probably IBM) God. There is no repository database against which it checks, the "database" is that particular map file which you are trying to run\test. Used for Any...