DSXchange

Thanks pkm. in the admin environment variables, we checked the instance name, instance owner, instance directory, database name, etc. then in unix, we checked the group and the required permissions... its working, thats all i want!..lol bye jay :oops: Ok...I guess I should have the question in more...

hi guyz this is an enquiry... the doc for Enterprise Edition says that the BASIC Transformer stage is amongst the new enhancements....but i dont see it in the Processing Palette...but the other 3 stages are there!! my question is it there in the Server jobs and not in PX...logic says so...or did As...

Hello all, I have been assigned to help the PX admin to separate the PX Developers and the PX Administrator. Currently all the developers have Admin rights. Can any one suggest some pointers as to how sould i proceed? I did some R&D and found out that i can do this at the database level and uni...

Hi, I've just create a user TEST with role of Subscriber. How could i log in with as this user to metastage directory from metastage explorer. Thanks. If you created a user TEST, then this user "TEST" must be a valid user on your windows workstation. You can do one of two things: 1) Eithe...

Instead of making entries into the VOC file, try doing this to make your shared containers read only. Design info about the job objects in a container are stored in basically two tables (or Hashfiles): DS_CONTAINERS AND DS_JOBOBJECTS. You will need to find the appropriate CONTNO and udate the field ...

Hi Siva, Instead of trying to query internal tables and generate a report, you can try doing this. In MetaStage 2.3 and above, you can selected metadata objects to a relational schema which can then be queried using any front end BI tool. To do this, select the objects (a category in category browse...

Hi, Yes! MetaStage scripting can be used to capture ETL process metadata from programs other than DataStage. Documention for a sample proxy script can be found in Appendix C of your MetaStage Users Guide. As far as capturing Metadata from other ETL tools, MetaStage 6.0 does have a MetaBroker for Inf...

Hi, What type of metadata do you want to see together in one place (I assume metastage)? If you are talking about static metadata such as Table Definitions from ERWin, DataStage, and MetaStage, do you then want to be able to compare and match the use of these objects across these tools? Then, the op...