DSXchange

Thx to all of you - <NVL> is the key to the solution - thx again

Thx to all of you - but i still have some problems: i created two stage variables 'A' and 'B' A = CRC32(FromTRS00_i.ACC_YEAR:FromTRS00_i.FINANCIAL_YEAR:FromTRS00_i.TREATY:FromTRS00_i.TREATY_SECTION:FromTRS00_i.PERIOD_START_DATE:FromTRS00_i.PERIOD_END_DATE:FromTRS00_i.RESP_DEPARTMENT:FromTRS00_i.RESP...

Hi All,

what is the easiest way to compare two oracle tables with 25 attributes and up to 100.000 rows and write out the differences ?

Thx
Matthias

@chulett: that's it - thx !!!!

sorry: problem NOT fixed...delete from #table# where year = year deletes ALL records...

i want to delete all records with year = 2005 but this value (2005) comes from the SAP extract an is not common in advance...

Problem solved with: delete from #table# where year = year

thx

works with a constant, e.g. year = 2005 ......???????

hmmmmm...okay...i have 40 incoming links...in my insert command, all these 40 links are defined, so how to define them in the delete command in the before-tab of the oci-stage, when the only key is YEAR ?

and tried it with year = :40 .... ora-01008

thats what i tried:

**I tried it with the before-stage: delete from #table# where year :=40

Warning:ORA-01008: not all variables bound

i'm using the oci-stage and :40 is my link variable for YEAR....

Hi there, i'm extracting data with the SAP BW Extract-Pack. One attribute is YEAR. I like to write all the extracted data into an oracle table. Problem is: i like to delete all the existing data of YEAR from the oracle table and then write all the new data into the oracle table. e.g: extract pack co...

Hi there, is it possible to retrieve data from a (hierarchy)table and not only from an info object with the extract pack for sap bw? i created an info spoke but within that info spoke it is only possible to select *info cube* or *ods object* or *info object* as data source, but i need to extrect the...