DSXchange

I need to check a range of values for a column and am creating a routine to check for the list of possible values Begin Case Case Arg1 = 'Fiat' or Arg1 = 'FIAT' or Arg1 = 'fiat' THEN .... Case Arg1 = 'Ford' or Arg1 = 'FORD' or Arg1 = 'ford' THEN .... .... End Does D/S have a faster method like the I...

Hi Micheal,

I definitely welcome any material regarding CDD, tips and tricks relating to ETL. But let's start with the lighter materials, fairly new to this area [:)]


cheers
Billy

Hi Stephan & Rasi, Thanks for the advise, I am extracting from the source into the a temp DBMS which supports sub-select statements and then I extract it out into the staging area again for JOINs I'm new to the ETL and perhaps this may sound like a naive question - from your experiences is it no...

Hi All, I've been going thru the course materials and I noticed that the CDD (Change Data Detection) method requires the extraction of the entire table into bkt, src and hash files. Based on all your vast and many years of experience, is this the best CDD method for a DBMS w/out a timestamp feature?...

Stephan Yes, this works. We also have another similiar problem but this is even more complex. TranNo TranCnt TranCo Amt TranDt 000001 0000000 ABCCom 100 1/1/01 000002 0000000 DEFCom 100 1/1/01 000003 0000000 GHICom 100 1/1/01 000001 0000001 ABCCom 100 3/1/01 000002 0000001 DEFCom 100 3/1/01 000003 0...

Hi Stephan Looks workable and good. However I will still have to perform an additional SELECT statement to get the cummulative figures from the previous week. All these are part of a pretty complex subset of the final table we wish to get. We need to accumulate based on a certain range and the full ...

Hi Stephan The objective is not to get the max date but a cummulative amount. Let me give an example Table A ------- IDNo Tran Date Tran Amount AAA 1/1/01 100 BBB 2/1/01 100 CCC 3/1/01 100 AAA 1/1/02 100 BBB 2/1/02 100 CCC 3/1/02 100 AAA 1/1/03 100 BBB 2/1/03 100 CCC 3/1/03 100 AAA 1/4/03 100 BBB 2/...

Hi Rasi,
Yes, I have thot of that option unfortunately the DBMS I am using does not support sub-select statements. FYI, the DBMS is Progress.

cheers
Billy

Hi, I have a table transaction (IDNo, Date, Tran amount) which I have to UNION back again based on the IDNo to get the cummulative tran amount. Something like : SELECT a.IDNo, a.Date, (SELECT SUM(b.Tran amount) from table b where b.Date < a.Date and b.IDNo = a.IDNo group by b.IDNo) from table a Can ...