DSXchange

kananthan wrote:How to see the data in the Dataset in UNIX. What command we have to use to see the data in Dataset in UNIX?

Use the Dataset Management tool from the tools menu in any of the client tools.

Ray, I guess the lookup file set doesn't suffer from the same restrictions as that seemed to work, although I'm still testing to establish whether the lookup fileset does the equivalent of a truncate and load rather than an append. What in yor mind would be a reasonable approach to replicating the S...

So is it not possible to implement the equivalent of a hash file r/w in a single job using PX?

I'm trying to use a single dataset(once as lookup and again as target) in the same job. Can someone please let me know if this is possible as I keep getting the following error. Operator initialization: A link between two operators should be named with a .v; insert a copy operator to save a persiste...

What is the file type?

Do you mean it has a variable record lengths within the same file?

Shai

Can anyone explain the following. I'm loading some numeric data into a dataset. Datatypes are integer. I use an aggregator prior to the ds which throws out a dfloat, which I then modify. Without the aggregator the ds is created with int32 datatypes. However, with the aggregator the datatype is dfloa...

Sorry, let me expand. I have a single input stream inserting into multiple tables on SQL server. The commit level is set to 0 and the record lengths vary depending on the jobs, but all seem to follow the same degradation of performance path. I have been told that it may be the way the box is configu...

I have a set of jobs that each insert records into a SQL Server 2000 db. I'm finding that some jobs insert at rates of around 800 rows/sec wheras others do as few as 25 rows/sec. The main differences between the jobs seems to be the number of tables/connections that the jobs make (ie the number of c...

A bit of everything, but QAS actually launched a front-end showing the throughput and memeory usage. We have also checked this against the Performance Monitor.

Not only this, but visibly (in duration) it takes hours longer from within DS then from the command line.

Can anyone explain the following. I am making a call to an application called QAS (address cleansing) from within Datastage, using the command line stage. When this runs it is allocated upto 3MB of memory. When I make the same call from the Windows command line the QAS app is allocated upto 300MB. I...

I'm trying to use the DSLinkInfo to obtain a row count. I keep getting a value of -1.

Any ideas why this may be.

I'm calling the command from a sequencer after the job in question has run.

Thanks
Shay

This has all been very useful thanks. I've narrowed the problem down to the target load and the commit size. Can anyone tell me how I now optimise the Parameter Array Size. I'm currently using 250, but when i used a higher value the job gave a compile time error. Should this value be the same as the...

Does anyone know the best way for me to figure out what's strangling my Datastage jobs. I have several jobs that run in sequence, some parallel some serially. They either read from flat files or hashed files and all write to SQL Server tables. In between they do some very simple transformations invo...

For routines to work correctly I see that 0 is required for a success. What is the case for User Status. How can I use this with restartable sequences?

Does anyone know how I can stop phantom error messages appearing on the log. I have a simple outine that receives a parameter and checks for Null or an empty string. The problem is that when the routine is passed a null I get the message "variable previously undefined....." as a phamtom in...