DSXchange

I have searched this forum on the many ways to handle null values. I saw several posts that specified that some handling can be setup on the source and target stages through the "edit column metadata properites" dialog box. However, when I try to use this method, (Note: I have tried for al...

I have searched this forum on the many ways to handle null values. I saw several posts that specified that some handling can be setup on the source and target stages through the "edit column metadata properites" dialog box. However, when I try to use this method, (Note: I have tried for al...

We are on AIX so not sure if patches will be the same. Here is the list of patches by ecase (in the order they were applied) from Ascential that we have applied. 75003 (The DRS plugin and the ODBC stage are incorrectly placing an unqualified tablesname in the stage when afull-qualified name is selec...

I'm afraid that we did not anything special. We installed the plug-in when we installed the base product. We did not select one node only and we have two nodes configured. The job runs, but is slow in both sequential and parallel mode. We set the job up exactly the same as the sequential except that...

For doing straight inserts we can insert using the teradata mload at only 15k rows/second (This is with the stage in parallel). Very slow and uses a lot of cpu (240 out of 400) on the datastage server. Using the teradata enterprise stage we achieve 120k rows/second ( using only 60 out of 400). Much ...

Note: When I said project above in the following two paragraphs I meant to say both project and job. We make a backup of the job requested to go from development to QA in version control and an additional dsx copy into an OS folder named by project.job and route (development -> QA). When the job goe...

We have our systems setup with a function/development test, system/QA test and finally a production system. The flow is development -> QA -> production Everyone ( that needs ) has access to development. Only myself and one other person have access to migrate and change jobs in QA and production. We ...

I only call it a freeze if the user can perceive it. The user cannot and thus I don't consider anything as frozen.

I'd also like to mention that when using these utilities to backup the databases no tables are read! Only the allocated blocks/pages. These blocks/pages contain the timestamp of the database. When your flavour of DBMS does its hot backup ( Sybase, MSSQL, Oracle, and UDB ), it simply gets the current...

There is absolutely no freeze when I do a full database backup for Sybase and MSSQL. I use RMAN to do a hot backup of Oracle and I don't believe there is a freeze there as well.

Fine then, but you are incorrect also. The transaction logs are used to get a sequential list of changes or a "delta", but you still need a baseline from which to roll forward/backward and in order to get that baseline image the database still effectively needs to be in a quiescent state a...

Ray.Wurlod wrote: 'This is true of all databases, really, though there are some strategies (like snapshots) that "pretend" it's a quiet time.' That is a lie. That is what the transaction logs do for us. They give us incremental recovery ability. In addition, they provide the database with ...

A question related more to Oracle than the STP stage. Why is Oracle so slow at returning a result set of data in procedure? Is it because Ascential is looping through the result set through a cursor? Sybase can return the same data 25 times faster through a procedure on a IBM RS6000 server that is m...

Thanks. Your example package works. Nothing like the Ascential documentation.

However, the STP bug I wrote up exists with Sybase, Oracle, and DB2.

Would appreciate it if someone could please provide an example of a Oracle package with a simple procedure to return multiple rows to the STP stage? Please provide both the Specification and Body of package. The example in the Ascential documentation is riddled with errors and does not even return o...