DSXchange

Search asktom.oracle.com use ORA-1480. It is a bug. There is a fix for it.

The reindex command requires exclusive access to whatever it is indexing. You may have corrupted the hashed file you are trying to reindex. If so then the reindex command will never work. Try this command: COUNT DS_JOBS COUNT DS_JOBOBJECTS If you can count these hashed files then maybe they are not ...

Awesome Ray.

How much is it? Do you think we could get a volume discount?

You got it correct. You need to write a job which moves the tables above to load them into hashed files of the same name. You need to create these hashed files somehow before running this job. If you want you can write a job to pass these from the hashed files into the real tables if you need them t...

I am not sure why Ray thought you were done asking questions.

Yes the open is for hashed files. I will have to look at the job in question to see what it does.

ETL_JOB_HIST
ETL_ROW_HIST
ETL_PARAM_HIST

Are jobs updated by the job you ran. The DDL to create all the tables updated in EtlStats are in the zip file in a folder called DdlScripts.

Most of these jobs in EtlStats were built in my spare time. A lot of these the customer said no and I built it anyway because I knew it had value but I could not explain it well enough for them to want to pay for it. After a while they just turn me loose knowing I am better at delivering than explai...

This is a very complicated process. It is hard to explain. I have tried many times to explain. If you get it working then please let us know.

I can also sum fields. So fact tables can be QA'd.

The QA jobs in EtlStats are designed to count records in source and target and compare them. I have posted links to the reports which are generated from this type of automated QA process. The way it works is it requires you to out SQL statements you want run in a table called ETL_QA_SQL. There is a ...

I would say you need this job posted and what Ray was talking about. You need to load up EtlStats. Once the job run times are in a table then sort them by run date then you will have the order the jobs ran in.

EtlStats will do this. In the QA jobs it can count both the source and target tables and email you a report of both compared together. This is called a completeness report. You could use EtlStats just to get the row counts of all the jobs ran. There are jobs within EtlStats which can extract the tab...

You could modify DSJobReportDbDriver and strip out what you do not want. I would rename it so you can upgrade to the next version of EtlStats. You do not have to call DSJobReportDbDriver at all if you want. You can run DSJobReportDb directly. DSJobReportDbDriver was created so at the end of a sequen...

I have no idea what you mean by: what sequence they are called like 1) Extract 2) Transform 3) Insert 4) Update This would help me in showing the status of the sequence jobs in the same sequence they are called. The sequence name is in the same row as each job that it runs. You would need to add pro...

You will need to create one dictionary item. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM ) VALUES ( 'JobActJobName', 'D', '12', 'JobActJobName', '30L', 'S' ) ; The DSX is at m You need to create this table: Create Table ETL_SEQUENCE_JOB ( SEQUENCE_JOB_NAME...