DSXchange

Hi Ray, the 'requires' part... ;-) Especially given that it is perfectly possible to create a table without a primary key, but with a unique constraint, I'd have thought that if it actually needed a unique constraint there would be some way of telling it which unique constraint to look at.....at lea...

Hi All, can't find a CDC forum here....so I guess this is the 'next best one' to put this question on?? Sorry if it's not... We have installed and tested Change Data Capture. We are doing an Oracle Apps DW. One thing we found, which is confirmed in the documentation, is that CDC 'requires' the oracl...

Hi Ray, well spotted, I didn't...the guy who worked on the problem told me he did, but what he meant was it was exponential in TOAD.... So, this is what we have found now...might help others.... I put an append up previously here... http://www.dsxchange.com/viewtopic.php?t=88325&highlight=126,38...

Hi All, we are just doing our final 'clean up' of all the 'data type mismatch' warning messages that get generated. We have tons of them as we are moving a very large number of fields (3,100) and the target data types are frequently different to the source fields.... It strikes me that it would make...

Hi All, oracle apps has some fields defined as NUMBER, such as XYZ NUMBER, with no precision...we had changed all these to NUMBER(38) which is (38,0) and gotten the fractional truncation message. We switched back to NUMBER only in the target database and what we find is that NUMBER can also return a...

Hi All, we have been doing 'day 1 startup' testing where we have been running full volumes of data through DS....one thing we noticed was the /dstage directory where we installed DS is getting used up rapidly....we traced the problem to fractional truncations where we accept a field which is 'number...

Hi All, I could not find a forum for PACKs so I tried here. We recommended to the client that they simply put triggers into Oracle to detect the deletes since there are very few deletes happening...but the client would like us to research other ways of getting deletes from oracle apps... We are extr...

Hi Greg, it can be very hard to find small differences between development/production servers if you have different people playing around with software on them.......my only suggestion is to have someone who really knows the OS and DataStage go through each of the system parameters and look for a di...

Hi Ray, yes, I agree that a far better way of 'manual restarts' is required in DS... I have had the unfortunate experience of a person manually correcting a batch stream after a 'running out of space' failure and messing up the database beyond repair.......and since the downloaded change files were ...

Greg, something you might want to consider is to reduce the number of jobs invoked...DS must start/stop each job and it must log all this activity. This is not a problem on unix (it used to be on win2000) except that you generate very large logs etc. and all this stop/start/logging takes time.... So...

Ray, you know me too well... ;-) And you are right, the only place for data to live is in a database and DW_BATCH_CONTROL is, indeed, in Oracle... However, it is trivial to copy it to a hash file at the start of the batch.....The way it looks like is best to me is just to copy the table to a hash fi...

Hi Michael/All, of course, I would expect that a developer (very likely) has no say at all over hardware purchased....and that it is also likely that the customer (or someone) has mandated the environment.......but that's not to say the mandate is sensible/reasonable or can even be made to work. And...

Hi Tang, we were all novices one time... :-) ....We just need enough information to be able to comment helpfully. In server you must run 'active' stages...so your job needs to be a text document -> transform -> ODBC stage where the ODBC stage calls the stored procedure...then you can run your job......

Hi All, I have a table called DW_BATCH_CONTROL which contains a field called BATCH_COMPLETE_FLAG. The second thing a new batch does is insert a new row setting BATCH_COMPLETE_FLAG=0. The first thing I want my batch to do is to perform a select count(*) from DW_BATCH_CONTROL WHERE BATCH_COMPLETE_FLAG...

Tang, when you post here please provide details of exactly what the problem is, then we can help you. Just saying you have difficulty and are a beginner doesn't give us enough information to help.... Also, the first thing you should do is the DS training....There is an excellent 5 days of training i...