DSXchange

ray.wurlod wrote:Do let us know how you get on.

And also, if they continue to refuse, how they suggest you work around the fact that the Oracle Enterprise stage can not be used.

Hey, Thanks all for your feedback :D . I will keep you updated on this.

Thanks
zzgani

But my client is adament on not to give these select privileges on dba tables to ETL user account as they are against the Sox compliance . I'm sorry, but that is just so wrong and shows a poor understanding of what 'Sox compliance' means. Without those privs you are SOL. So, it's ok for the ETL use...

Hi, We are planning to do a full refresh of our staging tables from the source system (Oracle ERP) on a daily basis. Our staging tables (Oracle 9i) in this case are just a mirror of the source tables (structurally same). I would like to know which would be the appropriate stage (in terms of performa...

Hi, I guess a lot might have been discuss about the need for select privileges on certain sys table for Oracle Enterprise stage to work. But my client is adament on not to give these select privileges on dba tables to ETL user account as they are against the Sox compliance . Is there any work around...

Welcome to DSXchange :D !!! Metastage in version 8 of Datastage is clubbed in to single pack. Datastage itself will have single point of common repository. ... ------------------------- Thanks Kumar_s for your quick response. But could you please throw some light by answering my following questions...

Hi, In our project we use Datastage 7.5.2 Enterprise edition. For Metadata capture,we are planning to use Metastage. But the only nagging concern is whether Metastage is scalable in other words what is IBM's proposal for upgrading MetaStage when they go to DataStage 8.0. I just saw in IBM site like ...