DSXchange

Hi, Ray is a RAY OF HOPE for every DataStage developer. Right from clarifying my questions on programming, he has been clarifying, helping with a sense of duty. I will like to add the thanks to every one of you for having made this a successful knowledge portal. My special thanks to Wolfgang who has...

Hi Ray,

Thanks for your valued response. I still have not got my answer for exporting the documentation as soft copies.

I can print to file, but am not able to open the file generated.

Can you help us?

Regards
Srinivas.B

Hi,

My actual question was " How to integrate a rule based engine " with our DataStage ETL tool? Have you done that?

Regards
Srinivas.B

Hi Ken, Thanks for the knowledge sharing. During one project which we executed , we had thought of a rule based engine, something like a Database table which stores all business rules with versions and other details. During run time, the ETL process/tool checks the rules out and changes to business ...

Hi, On version control utility of DataStage, the concept is simple.Only the design time jobs are editable while testing and production jobs are read only. Thus there will be three projects - design, test and production. Once you pass the jobs thru version control, they become non editable. the versi...

Hi, In many projects, we face situations which need the job design change. Thus the specs keep changing. To get the latest job specs, reporting tool comes in very handy. Am able to print the hard copies. Is there any way for versioning ( i.e to see what the spec was in the previous version) and also...

Hi,

In one discussion, the presenters were mentioning " NORMALIZED" Data warehouses...

I could not get more info on that topic. Could Ken or Ray share their knowledge?

Thanks in advance.

Regards
Srinivas.B

Hi, I agree with you that corporate awareness of Data Quality is quite low. While the acronym "ETL" or "ODS" rings a bell with most CXOs. Data quality does not figure very high on their radar .The reason for this being the assumption " once our DW is in place , data quality ...

Hi VMCBURNEY,

Thats very kind of you. I didn't know that jargon.

Thanks and Regards
Srini

Hi Ray,

Thanks for the response ... by the way whats bouncing the DataStage engine?
Regards
Srinivas.B

Hi Everyone, We have designed nearly 70+ job designs for loading a data warehouse using the ORA OCI 8 plug in. Client is migrating from 8i to 9i Data base and they have requested us to redesign the jobs in 9i. We had a input that the dsx could be modified to change all 8i occurrences in DSX to 9i. W...

Thanks a million Wolfgang and Wurlord, By trial and error , we have configured the ODBC .Now my question is which is the most optimal method of setting up of ODBC in such UNIX systems? 1. ODBC -common to all projects 2. ODBC specific to each project Thanks in advance. Regards Srinivas.B Srinivas.B I...

Hello Ray Wurlord and Wolfgang: We still are unable to configure ODBC between the Windows client (NT professional/Win 2000 server/professional) with DataStage Ver 6.0 or 5.2 to DataStage Server Ver 6.0 on IBM AIX 5L. Though we have come to the point where the DSN shows up in the list of the drop dow...

Hi, I am trying to configure ODBC for DataStage V 6.0 on AIX box. Edited $dshome/Ascential/DataStage/branded_odbc/odbc.ini file Made entry to ./Ascential/DataStage/DSEngine/sample/uvodbc.config While trying to import ODBC table definitions. It shows me the DSN (jpmdev) in the drop down list but give...

Hi, When I'm trying to execute the 'Reporting Assistant', getting the following errors. 1. Run-time error '429' ActiveX component can't create object 2. Run-time error '440' Automation error Is it necessary to have 'MS-Access' installed in our client work station? Could you please tell me how to fi...