DSXchange

I'm using a transform with a sequential file input and ODBC lookup. I want to extract all the records in the ODBC that match the key value in the sequential file. However, the transform currently grabs the FIRST record in the ODBC that matches, and not the rest. I know there's a setting somewhere th...

Thanks both of you for your help.

I gave a quick try using all fields as keys and it said ALL the records were not found. Probably has to do with some trimming or nulls, I'll have to take a look at that in the future.

I'll go with the Compare <> 0 for now.

For your non-numeric columns, use the Compare function. This will force a string comparison. OK, I tried this an it looks initially promising. Just testing on the one field, I changed my constraint to: Compare(NullToEmpty(Trim(existingRecs.test_code)),NullToEmpty(Trim(lkupDBRecs.test_code))) And it...

We're having a really tricky problem. Our daily processes updates Table B to stay identical to Table A. One of our server jobs compares the current contents of Table A to the existing contents of Table B. In this job, Table A's contents come in to a transform as a sequential file, and Table B's cont...

Hi All, 2.) We faced this as a one off problem but i am still trying to figure out the root cause. There has been an occurence wherein a sequencer trying to call some jobs suddenly crashes with the following error. Controller problem: Error calling DSRunJob(JobA), code=-14 [Timed out while waiting ...

kduke wrote:FTP stage.

So that means the Windows 2000 server would need to be running an FTP service, right? That's not something standard is it?

What method in datastage (or command shell) could I use to transfer a file from a Unix server to a Windows 2000 server?

It can be done, as far as I know. Do a search in this forum for remsh to see various discussions on this topic, that should get you started. So if I want to do that with DataStage, I would use an ExecuteCommand stage in a sequence job, right? Is there any way to use DataStage environment variables ...

Is it possible for DataStage on a Unix server to remotely execute command line commands on a separate Windows 2000 server?

I cannot find any information about DataStage support for Geospatial data types, such as shape files, coordinates, etc.

Has anyone used DataStage for this purpose?

I've been reading this thread and trying to make sense of it, but I can't find the example mentioned There is a reference to design a job like OCI/ODBC --> xfm --> hash that selects max on the surrogate key column in your source table and writes the current value into the hash file SDKSequences in t...

A couple of times, DataStage designer has frozen ("not responding") when viewing large sequential files. (Local client is Windows NT 4.0). When Designer is restarted, we have been unable to edit the job that was being edited when the error occurred. The only way we have found to release th...

When I import an ODBC table definition, then load the column definitions into an ODBC stage, I have a problem. The "derivation" for each column includes the database name, table owner, and table name. e.g. Instead of having "customer_name" in the derivation, it has "dev_db.d...

Ascential also teaches a class called Iterations (IT400), which is their methodology for developing a DW. They show you what parts of a project that their tools like DataStage or AuditStage plug into a DW project.

It is a good primer for a DW project, although their techniques differ from Kimball's.

I ran into this same problem, but it seemed unlikely that the routine name was misspelled because I selected it from a drop-down list in a routineActivity stage. After reading the advice in this thread, I found that I had selected the function from the list, then went and changed the name of the fun...