DSXchange

If DataStage server is installed on drive X, then X:\tmp

Substitute for X as required.

It would have been more efficient to sort once, either during extraction or ahead of the Copy stage.

Do you have a folder called tmp (not temp) on the drive where DataStage server is installed?

If so, do you have write permission to that folder as the user that executes DataStage jobs?

I wonder how you know that? Ah yes, California...

Job type is marked as server

In a parallel job the First/Last functionality is provided by the Remove Duplicates stage.

There have been problems reported with particular data types. I can't recall the exact details, but a Search should find them.

Correct terminology is HASHED file, not "hash" file.

To empty a hash file I imagine you would use a wire brush of some kind.

A hash file is a tool for shaping a block of hash.

Simply you can add a transformer before hashed file and you can pass null values to the columns ... That is wrong. What you do is set up a constraint expression (such as @FALSE) that allows no rows at all to pass. If you send NULL to a key column you end up with a warning in the job log. You ought ...

The Aggregator stage itself will allow you to generate First and Last.

Moderator: please move to server forum

What is different between PROD and DEV servers? ("Nothing" is not the correct answer, clearly.) Concentrate particularly on how the connection to Netezza is configured, but allow that it might be something else.

How did you effect the migration?

You will need to decompose your input timestamp into date and time components, adjust the date component, then reassemble. You do not have to convert to string (which is what Craig suggests) - there are functions such as TimestampToDate() that you can use.

That is something I refuse to do. I will, however, warn you that the interview question "cheat" sites that you might find on the internet are usually terrible, and contain answers that are patently wrong. The correct approach is training, study and experience using the product. You learned...

Many ODBC drivers (sourced from DataDirect) ship with DataStage; these are to be found in a directory called branded_odbc. There are plenty of "read me" files there. For any other connectivity you will need to obtain UNIX-based ODBC drivers; there are several vendors which a simple interne...

Actually we are getting review comments from the external contractors who are working as a DataStage professionals about removing the Sort stage. They are saying that Sort stage is not needed as the partition will be preserved. Partitioning and sorting are not the same thing. The comments are corre...

parag.s.27 wrote:Is it possible that after spliting the data the Stream 1 may get records in Un - Sorted manner and thus the Remove Duplicate stage will yield incorrect results?

No.
There is nothing in what you are doing that would affect the sorted order.