DSXchange

Try to put your reject link through a transform stage, you can use this stage later if you need to abort your process if you have any rejected records. Add a Peek stage to the tranform stage make sure that all the columns appears in the input of the peek stage. You may have this already but check th...

Hey Ray, No compilation errors are generated and there are no flags set. The most the transformer stage has is an IF, Then , Else statement and some may in addition a convert function. With some stage variables mixed in. Strange thing when a peek is added to the Transformer stage there is data , the...

Recently migrated several jobs from the Linux DEV Server to the QA AIX server. Currently some of the migrated jobs are now producing NULL values for all the output fields, regardless if the output is a file, peek or table. Placement of a peek prior to the transform stage shows correct data values. I...

DataStage 8.5 CDC 6.5 O/S Linux Using CDC to DS which creates a Sequential file, in the file there is a 4000 char field that has embedded LF and blank lines. The Seq File fields are enclosed in double quotes and are comma delimited, the source for CDC is Oracle. The problem is that the process abort...

James,

it's worth a try, I'll update this post with the results.

thanks for your time.

I want to utilize the same set of DS jobs, the challenge is the sequential source file records are the name of each of the table names that will be used for input. here are the steps: >file has a table name in each record >read the record >use the retrieved tablename as the source >run the DS sequen...

Giving this a thought you are correct about using this forum it really isn't really for this problem. I presented it to an Oracle forum.
Thanks,
C.

After installing Oracle Client 11g, I can not connect to sqlplus. I check the bin directory and I can see sqplus with a size of 37 meg. The install was successful, I ran the required scripts at the end of the install. I am at a lost as to why this is not working. I completed the same installation on...

This is a new installation of 8.1, there are 2 LPARS, edwetldv1 for the engine components and edwmsdv1 for services. I sign in with edwmsdv1 to Information Server under the Administration tab -> Domain Mgmt -> DS Credentials instead of getting edwetldv1 I receive the msg 'No data found' . :?: I appr...

Craig, This is a brand new installation I created a test table in the same schema as the metadata repositories is in, however I can't import the table definitions using the Orchestrate schema definitions. This problem is also in my dev environment, but in dev I can access the table using the Plugin ...

This is a new installation, no Prior DS version in effect. In Designer in the Import Plug_in MetaData when I select the Oracle Name I get the following error: Error calling subroutine: DSR_IMPPLG (Action=1); check DataStage is set up correctly in project projname (the connection is broken (81002)) I...

Current water cooler debate that maybe someone outside can help with this discussion. For daily loads to Oracle Fact tables, that can have millions of rows. Would an Upsert work faster than the Change Capture Stage that will compare each input record from the daily transaction against each record in...

I may already know the answer to this question but I figured I would amuse myself. :D
Is there any way to check the execution stats of a shared container while it is being executed, similar to viewing a regular DS job running in Director.

I checked with our admins and they do an incremental backups daily. So I will get to check out first hand how well we can recover from the backups. According to the admins the backup includes all the directories, so I will be doing a complete restore. This will let us know if we can actually restore...

I am looking into how to recovery my DS environment for one of our servers that was taken off line and cleared out by mistake. I can re install DS ver 7.5 on the Linux server. Is there a utility that will load the DS processes from the backup, which is a total backup of the server that is done daily...