DSXchange

That's an entirely different question. The solution probably has to do with space characters. If any of the lookup keys are Char data types, they will have trailing space characters in the table - your reference key expression must provide exactly the key value needed, including trailing space or le...

What stage type are you using?

If your design has 3 in the Scale column for the timestamp get rid of it. If your design does not have 3 in the Scale column for the timestamp, add it. Your design must match what the table expects.

The UNIX command in Ross's code will probably work in DOS also. At worst you may need to change the pathname delimters from "/" to "\".

Beware, too, of case. It's ExecDOS, not ExecDos.

What is the value set for NLS_LANG environment variable?

You won't get any rows out until the sort has been completed. Five hours seems a lot for 500k source rows, but how many sort keys are there?

If you use HFC you will realise that it's quite easy. You enter the total number of records and the average record size - and choose a hashing algorithm from a drop-down list. HFC does the rest.

There are at least three configuration files, uvconfig, uvodbc.config and (for parallel jobs only) *.apt. So the first refinement of your question is which of these you are asking about.

Hi ravi, i tried using the aggregator.But it is also not giving me the total count.Instead it is giving me a sequence number like 1,2,3...10 again. Thanks, sengs You can not get the final count until the last row has been processed. Think about what happens. Read the other suggestions (Transformer ...

That is correct. The only thing that should be on the server is the Package Installer.

All other menu items are client-side only.

To emphasise what Ken said, the FTP Enterprise stage (or the FTP stage in server jobs) is intended to move one file to/from the remote machine, with the file contents delivered/taken as a stream from DataStage (that is, not landing to disk).

I believe you will find that that information is not in the public domain. You might try asking the vendor.

Given that the input needs to be sorted on the keys, I think you can figure out how it works - you can do the same thing with stage variables in a Transformer stage.

Arnd is correct. Job designs are stored as records in tables in a database (the Repository). The deletion having been auto-committed, no recovery is possible. There's a lesson to be learned about backups here! I export all my work at the end of each day. There is a record in the DS_AUDIT table that ...

Welcome aboard! :D You have a steep learning curve. The first step is to garner some understanding of what a slowly changing dimension is. There are many books out there - one of the best is The Data Warehouse Life Cycle and Toolkit by Ralph Kimball and others. Slowly changing dimension tables imple...