DSXchange

Yes i got it by using 2 passes!.

Lets say I have ProdNumbers, Invoice, Sales, Load_Date, all i need is Sum of Invoices, and other fields I need them as it is.
Thanks,

The other columns have different values which we need, so select from first or last would eliminate the other records !

Hi I have few columns comming from source, and I need to aggregate only one column and pass the rest of them as it is without applying any logic or aggregation on the rest of the columns. The isue is when I use the aggregator stage, I HAVE TO select some kind of aggregation on every column , is ther...

Hi I got the issue resolved, had a key field issue.
Thanks,

Hi, I have created a hash file from an Oracle table with only one column. When I right click the file I am able to view the data. Now in my other job when I give teh same path and file name for the hash file , I get an error saying "PartHash.DSD.UVOpen Unable to open file" Checked in unix ...

Thanks Ray, it makes sense now.

My question is, can I populate the column even if there is no match in the hash file. If so how do I capture the value.

Hi,
I have built a hash file of all the part numbers from table2 but what happens if the part_no from table1 doesnt match part_no from table2, then I need to populate the field with 999 else with part_no.
Thanks

Hi Kim,
Can you let me know som eof the issues you are having which were not in 7.5.

Hi, Right now we have our development environment at DS 6.0.1, we are planning to upgrade to either 7.5 or 7.5A. 1) Not sure which version 7.5 or 7.5A is better. 2) What kind of testing do I do with my current jobs after the upgradation and is there any testing to do before the upgradation to get a ...

Thanks Arnd, we we donot have an issue with it right now but this is the question we were pondering over now at design time. One or two preferred strategy to avoid it would be good to start with.

Hi,
How do handle static Hash File corruption? And also the best strategy for data staging (database table / Flat file).

Thanks

It is not a "0" it is German characters and symbols. Did try all the options in the NLS map list.

hi,
I am extracting from Oracle 9.1 and loading SAP BW. One of the field is Char and the values are alpha numeric. My issue is DataStage is replacing zero with "?" . Doesnt DataStage accept "0"s in Char when extracting from tables.
Any idea would be apreciated!.