DSXchange

Thanks chulett! That worked... the default date format was the issue.

I'm testing a new ODBC Enterprise connection to an Oracle 10g database. I'm using user-defined SQL, but I've also tried the table read method with no luck. All data from the table is being returned instead of just the rows qualified by the "where" statement: select * from clarity.or_log wh...

Can't you use the Read Method = User-defined SQL to manually insert your SQL block on your ODBC stage? Why use the ODBC stage instead of the DB2/UDB Enterprise stage?

Thanks Ray. Maybe it was just done to add an extra description of the lookup failure like "Department Code Not Found". Is there another way to add a reject description from the Lookup stage?

I inherited some jobs that were built under version 7.5 but now we're running v8. In each job, the lookup stages do not send rejects down a reject link. Instead, a transformer stage parses the rejects after the lookup stage and sends the rejects down a link using stage variables. Was there a bug in ...

The new DataStage certification is available! Nine less questions than the v7.5 exam, so they dropped the maximum time from 105 minutes to 90 minutes. The passing score is still 75%. The cost is $175 USD in the United States.

http://www-03.ibm.com/certify/certs/28000401.shtml

Change your upsert to be update only. Then you can change the option on your upsert stage to Output Rejects = True and send your inserts down the reject link. Then add a separate stage to do your inserts. This is in the DX436 training manual as the recommended best practice for performance when you ...

Looking for an experienced DataStage developer to join our growing data warehouse team. Full time position located in Danville, Pennsylvania. Primary tools: DataStage, Information Analyzer, Metadata Workbench, Business Glossary, DB2 and Business Objects. Use this link for more information and to app...

You could export the registry key from the command line, then read the file.

http://support.microsoft.com/kb/168589/en-us

Is there any third-party training available for DS v8? The IBM training and Powerpoint slides are really terrible and we have new people to get up to speed that don't have an ETL background. Besides the IBM manuals and Powerpoint training, are there any other good options?

We have experienced this same issue (hung on login screen) several times with our recently upgraded v8 system with the same resolution each time - restart the server. I'm interested in a better resolution also.

Thanks for the replies and I hope to hear more about Aruna's experience with the product...

Is anyone using Metadata Workbench? It was released in June 2007 but we're having a difficult time getting customer references from our IBM rep. We would use it for data linage and impact analysis from our DB2/DataStage environment to our Business Objects reports.