DSXchange

Well, the requirement wants the evaluation of an expression (Field1+(Field2*n)) where n is (0 to (Field3)-1) so i was wondering if i split row into as many rows as Field3 value minus 1 then i can straight away use the formula at a "scalar" level. (oh yes and i need that many multiple rows ...

Well, DS does not support the use of IN statement (the SQL one)
however you could use regular expression and a decent text editor to convert your lengthy IN based statements to DS ORs.

Hi, I have a curious problem which didn't turn up in DSXchange search. i have a key column and a count column in the source, need to produce "as many" output rows for "that key column" in the source. Sample: (input) Key/Count 1,2 2,1 3,5 4,2 (output) Key/Count 1,2 1,2 2,1 3,5 3,5...

Hi Folks, Here is my dilemma: I have 200 columns in the input source and I need only 100 for downstream processing, Should I read all 200 with a dataset and drop redundant using a copy/modify stage as next step or should I restrict the metadata definition in the input dataset to read only 100 select...

Hi: I am using group property in aggregator to group columns according to the requirement...however i get the following warning when i try to view log in datastage director... AGG040: When checking operator: User inserted sort "SRT030" does not fulfill the sort requirements of the downstre...