DSXchange

Hi Ray, thanks for your reply.

The Netezza database doesn't have indexes, only distribution keys. BO is generating a job that contains a RowGenerator that executes a Netezza Stage with all the process included into the AFTER-SQL field.

Why? Cause i think the BO don't consider the partition options, only if we sort the input data in the stages, BO perform an ORDER BY clause in the optimized query. Analizing the optimized query, and the whole netezza stage itself, i cant see any reference to the partition options. I think that the ...

Yes, and i removed it to improve almost 3 minutes the join process.

Is it possible that executing a simple "SELECT * FROM TABLE1 left join SELECT * FROM TABLE2" between this two large tables is faster than the same operation using Balanced Optimization?

Nothing?

Hi guys! I have 2 Netezza stages with 500 Millions (left flow, with 200 columns) and 50 Millions of records (right flow, with 10 columns) each one. Then, I have a Left Join between that two flows, ending in a Netezza writing stage. I use the Balanced Optimization Tool to improve the performance in t...

OK, I've found why Datastage orders the parameters sets values in this way. As you may know, each value of the parameter set is stored in a different physical file. For example, in my case, for each value I have a different file inside the directory /ETL/Projects/R1B1/ParameterSets/HEADER_ETL_PARAMS...

Hi kduke, I've tried with both mouse button, and in combination with SHIFT, ALT and CONTROL keys, and no luck. Datastage seems to apply some kind of 'Hash' because if I insert a new value called 'TEST' it goes directly to the position 31. Then I change 'TEST' to something else, changes it position.....

Hi all, I'll like to know if its possible to order the values of one parameter set. For example, if you look at this image, we have several values for the parameter set called HEADER_ETL_PARAMS http://img837.imageshack.us/img837/1264/65381894.png But the values are unsorted, even if we have entered ...

Hi all! Let me try to explain the problem we have... We are trying to generate surrogate keys in our architecture, consisting in different jobs that loads different tables. The client requirement is that the keys needs to be different in all the system, so all the jobs will share the same key genera...

Hi,

I'm looking options to migrate Datastage jobs developed for the Datastage MVS version to IIS v8.x.

There is any litereature that provided a road map to migrate the Datastage MVS jobs to IIS v8.x?

There is any toolthat would help to do the migration?

Thanks in advance.

Hi all,

we are having the same issue. WE want to find a way of create an export by using our automated command line script without including these Data Quallity specs. they are causing the export program to abort.

Any clue about that??


Thanks
Julio

Hi, Following eostic workaround to add a copy stage between the dataset and the oracle stages now the link becomes green. I think remember that when datastage compiles a copy stage that is just mapping all the fields on the compiled code is like this copy stage doesn't exist. In case I'm right. Why ...

APT_NO_JOB_MON = False

Hi all,

finally we created a script which reads the jobs names from a test file and compiles job by job.

Thanks for your suggestions.

Thanks Sun and Sainath for you replies.

We know the existence of the multiple-job compile tool, but we need to do it using an scheduled script and because of this we use the dscc command.

Any suggestion about how to do it using the command?

regards