DSXchange

Good point.

Ray

I think the question was more based around QA type auditing not ETL design audit. They already have row counts supplied by MetaStage. Can MetaStage help in a QA process besides supplying row counts?

I think what not to do here is more important than what to do. Select InvoiceId From InvoiceFact, InvoiceDim, SourceLink@Invoices Where InvoiceFact.InvoiceKey = InvoiceDim.InvoiceKey and InvoiceDim.InvoiceId = Invoices.InvoiceId and InvoiceFact.InvoiceAmount <> Invoices.InvoiceAmt and InvoiceFact.In...

Simple audit should compare numbers from the source to the target warehouse. It should count or sum some number of rows to the source. AGGREGATE TOTALS: 1. Did all the rows in the source end up in the target? 2. Do the columns in the fact table total the same to the source? 3. In aggregate do you ma...

Thanks Craig. I never saw the question.

You need to probably change this into a job. All this code would go in job control code. You need to openseq, writeseq for each line then closeseq. Ray has posted a lot of code to show you how.

You should edit your post and ask a question.

I am not sure you need to reindex. I have seen this in almost every version of DataStage. I think it is in the DSX. I think you have a bad job in the DSX but I would love a full Wurlod.

Actually the key is a part of the string. Each level has a separate separator starting with char(255) which cannot be used for anything. This separates keys from the record also known as @FM. Char(254) is called a field mark. Char(253) is called a value mark also @VM. A value mark will separate mult...

They do not support BASIC in this way but it will work in you know how to make it work.

That is correct. All measures are 0. You can do the same with an outer join to the salesman dimension but sometimes this messes up OLAP tools. The purpose is to show all salesmen even if they had no sales. No sales maybe more important than who sold something. You may want to eliminate poor performe...

You have a write permission issue. You need to be root or an administrator.

Call support to get a more complete answer.

Usually someone (maybe a DBA) has killed this session. I would bet you are running out of rollback space.

A Full Wurlod just in time for the holidays.

Thanks Ray.

Download EtlStats from my tips page. It has all you need.

Use the same column twice except rename it.