DSXchange

Hi All, I am trying to convert the output of the aggregator stage column double to decimal[10,0] using a modify stage using the following function Add:decimal[10,0]=decimal_from_dfloat(Add) But Datastage throws the following warning. Mdy_Col: When checking operator: When binding output schema variab...

Hi,

Can anyone throw some light on the Accept Primary Keys Analysis in Profile Stage(Information Analyzer)

But I do not get a window to save the report as pdf. Any help apprepicated.

If the inputs are identically hash partitioned and sorted, then it will work. Therefore I must assume that there was some difference between the inputs in your case in how the partition and/or sort keys were specified. We checked it many times, we did not have any discrepancy in the Hash/Sort order...

Hi All, I have a datastage job in which the i am fetching data from a Teradata Connector and second from Dataset. I join the data using a join stage. When I am partitioning the data using Hash/Sort method on both the input links, the join is not provioding the correct output. But when I change the p...

Never, ever, delete jobs in that way. Even after Bryceson posts his findings about what's in the common metadata repository there are yet other things that will need to be cleaned up in the local repository, among them entries in the table of job objects (DS_JOBOBJECTS), and possibly references to ...

Hi Chulett,

But is this option present in UNIX?

Thanks

Hi All,

When we run the report and try to save it as PDF we do not see any option it provides to save it at any location. Could any help out here. We want to report the report as pdf file.

Thanks

I earlier used transformer stage only to do this. But when it was possible for a modify stage do it, I changed it.

I am not sure why DataStage gives this error when it is performing the same function.

Thanks.

Hi All, I am trying to convert double to integer using the modify stage. The source column is the output column from the aggregator stage that is defined as double with no length. The output column from modify stage is integer(10,0). I am using the following function in the modify stage. output_colu...

We are migrating all our DSjobs from DB2 to Teradata.... Only change would be the Target DB2 stage will be replaced by Teradata. I've tried modifying the dsx as well as xml Only thing we could do is we are able to add the teradata job parameters and remove the DB2 parameters...... By modifying the d...

We now have 16 node config file in production. Really not sure of the scratch disk space.. may be around 100MB with no node pools. It really retrieves us when you mentioned that space will be enough actually plenty. Thanks... So a record count of 216 millions will work? The only change will be to se...

If it is keys the size of the columns together is 19 chars.

Thanks

Hi Ray,

You mentioned 27 Millions per node is this a standard? in that case will 20 MB per node for a sort stage work?

Thanks

Thanks for the reply.
Ok... Wanted to know if any other performace tuning step can be applied along with disabling stable sort and using a new config file.