DSXchange

Ernie - I've never liked V8 too much, prefer something higher octane such as rum :lol: ... Friends, I'm in the process of evaluating a good utility to compare .dsx just to get an idea of what has been changed etc. So far from the board, I have heard of [1]UltraCompare...which does a decent comparis...

You don't need to know MS Access to use the reporting assistant. Your client installs a system ODBC connection called DataStage Reporting Assistant. Once you move your data into the Reporting repository from the Manager tool you can access the details in any ODBC enabled product such as MS Query or...

Difference stage outputs all columns (individually) from both input Data Sets, plus the result of the comparison as a coded value (codes are set up as properties) as one additional column. ... Ray, Can you slightly elaborate on this... plus the result of the comparison as a coded value (codes are s...

In the parallel job the inputs to the Change Capture stage need not only to be sorted identically on the comparison keys but also hash partitioned identically on the comparison keys. Have you ensured ... Ray, Thanks for the info. Happened to try out Change Capture for the first time[after trying ou...

IBM has its own Best Practices for DataStage. I haven't seen one, but heard of it. So you can get in touch with them to send it over. Hope this helps.

Hi all, Just wanted to know what is the difference between a filter stage and switch stage . as far as i know both do the same job. correct me if i'm wrong and could some one explain the same Thanks in advance In Filter, a single Input record can pass thru one or many output links aslong as each li...

I have a job wherein I am joining two datasets using a join stage and join type as left outer. I have sorted and partitioned both datasets on the join key. However, still I am not getting the desired output. I have around 6670 rows as input to the join stage, but as output, I get only 2099. I thoug...

ArndW wrote:Or write a simple job with the dataset as the source, a constraint stage (perhaps a condition in a transform) and then output to a peek stage. ...

Thank You Sir, That was my original thought, but I'm trying to see if there are other ways of getting around this...Thanks again

Hello All, To help debug, we have lot of COPY stages and written to Datasets. I can always View this dataset in full. But from this dataset, if I need to selectively view, it isn't possible. How do I go about this. One way I can do is copy this Dataset to a Sequential File, and once in Sequential Fi...

Hi, I have a file with 104 Columns tallying closely 1100bytes. I have numerous links of SORT,AGGREGATORS,COL GEN to Aggregate different TOTALs [total of 50 totals] based on a combination of Fields[ usually from a combination of 3-10fields] and FUNNEL into one final Output thru all these links. Today...

DSguru2B wrote:you can try g++ - O file.c to create its object file. I think
As Ray pointed out, try it out.

You can also used a Build-OP stage and do whatever you intend to do with simple C Programming.

FieldA <> 0 And FieldA_1 <> 0 And FieldA_2 <> 0 And FieldA_3 <> 0 And any other constraint that you may already have. ... Ray, by doing this, Only if all the four fields [FieldA,FieldA_2,Field_3,Field_4 are non-zeros] then the constraint gets satisfield. My requirement is if FieldA is 0, FieldA,Fie...

Yes, I meant in the first Transformer stage. And it's perfectly OK that this stage does "other stuff". All my suggestion adds is an additional condition on the output constraint expression - it does ... Thanks..I'm not getting a way to work out..If you can get me the expression with my ab...

Don't pass such rows through the first Transformer. Add the four checks to the output link constraint expression, conjoined with AND operators. ... Ray I'm not clear on this. Did you mean to have the four checks on the output constraint of the pivot ?!?!?! or do you mean to have an output link cons...

Friends, I have a scenario like this...The input to Transformer is a record which has 4 occurences of a particular set of fields.. e.g, Input Common Field1;Common Field2;Common Filed3; FieldA;FieldB;FieldA_1;FieldB_1;FieldA_2;FieldB_2;FieldA_3;FieldB_3 Output: Common Field1;Common Field2;Common File...