DSXchange

Pavan, Erwin is installed. It seems to relate more to the DataStage metabroker because it fails at the step when trying to encode the Erwin definitions from the intermediate file. regards, Peter -----Original Message----- From: Pavan Marpaka [mailto:pmarpaka@hotmail.com] Sent: Friday, 5 October 2001...

Peter, The way the filter/select all works is that when you initially import the ERWin metadata, it creates an intermediate file (dapgui ????) from which you can select and filter the table definition. Pavan Marpaka Datawarehouse Trainer Education Services Ascential Software Inc. 804-677-3346 (Cell)...

Hi All!

Does anybody have experience with MS OLE DB plug-in? Is it possible to create/populate cube in MS OLAP Services using it?

Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

Hi Peter, Do you have ERWin installed on the PC (where DS Client is installed)? If you have, then you shouldnt have any problem. I have done this several times and no problem other than the only time when I tried with without ERWin installed. You might want to call up the customer support. Pavan Mar...

Check the BASIC manual that installs under your DataStage clients. OpenPath has the same syntax as Open, except that you specify a full pathname rather than a table (file) name. For example, if you want to open /tmp and process each filename in it: OpenPath "/tmp" To filevariable On Error Msg = Unab...

Hi Simon, is the SQL Server users language the same of Datastage Server/Client? Regards, Riccardo ----- Original Message ----- From: "Simon Vollett" To: Sent: Thursday, October 04, 2001 2:59 AM Subject: RE: Combining date and time fields to create a timestamp > The same thing, still the failure, but...

In DataStage 4, it does mean using one job with parameters, making several copies of the job, and using Job Control to run those copies in parallel. From a development point of view (ie, time to develop and maintain), it is one job. To make modifications to the job, you change the first job, then re...

That is correct. I have one job, named something like "mAllLoadArInvoice" that I want to be running five times at once (to take more advantage of my machine), each instance of the job using different parameters. Currently, I am using DataStage 4.2 on NT writing to Oracle on UNIX. jason -----Original...

Im trying to import Erwin 3.5.2 metadata into DataStage. It seems to open the Erwin model OK, load up all the data from the model, but when I select the Filter or Select All button on the import dialog box, it returns to DS Manager with no sign of the metadata. I have loaded the Erwin 3.5.2 MetaBrok...

How do you run the same job concurrently in DataStage 4? I would be most interested. I assume you do not mean copying the job and changing parameter values as then it is no longer the same job? Phil -----Original Message----- From: lamont.lockwood@ascentialsoftware.com [mailto:lamont.lockwood@ascent...

Hi Jason, Which version of DataStage are you using? You might want to check into the latest version of DataStage 5.1 which allows you to run DSJobs concurrently with Axcel Pack. Pavan Marpaka -----Original Message----- From: Jason Mulvin [mailto:jmulvin@fuse.net] Sent: Wednesday, October 03, 2001 8:...

The same thing, still the failure, but in the mean time I have had success using the transform DateYearFirstToODBCWithTime. Looking at the internal documentation for both these transforms in Manager, it would seem that both should do the trick, but in the help documentation the DateYearFirst transfo...

What happens if you declare the data element for this column to be TimeStamp?

Thanks everyone for your help. My problem now is that I cannot convert this string YYYY-MM-DD hh:mi:ss into a suitable format to have it imported into a SQL server datetime field. I try using the skd transform DateTimeStampToODBCWithTime, yet it will not convert the string giving an error message tu...

It sounds like two different questions: 1. Can you assign Job Parameters to DataStage jobs? 2. Can you run DataStage jobs in parallel? 1. DataStage supports Job Parameters in many fields throughout DataStage jobs. Some fields allow selection through a button "Add Parameter" and others simply by addi...