DSXchange

The application, C:\Ascential\AuditStage\AuditStage.exe, generated an application error The error occurred on 04/06/2009 @ 11:03:57.381 The exception generated was c0000005 at address 73675E11 (MSVBVM60!_vbaGosubFree) Terminate the program, edit the Macro to contain the remaining filters and restart...

Starting AuditStage gives us following error message with OK button "Error retrieving domain values: The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time." We are all getting this message even when we are...

While running a macro in AuditStage a transcript warning appears: "Transcript window is full Can not write text" After klicking OK the macro continues however no new messages are written in to the transcript file. How can I expand the size of the transcript window? Because I want to have a...

We want to store the exception tables (generated while running the Datafilters in AuditStage) in excel or csv format preferably as readonly, reason we want to archive these exception tables (so they cannot be changed anymore) and we want to be able to explore the content of these tables using Excel ...

After conversion, we want to compare customer names. Customer names have been deduplicated enriched, updated, currently a lot of customers use the same customer number name, address description, where we used a number of descriptions in the past, a lot of these descriptions look alike, but are not e...

We have 2 files containing Contract Nbr, Asset Nbr, Invoice Nbr, Invoice Amount 1. We want to compare the total invoice amount per contract between the 2 files and if the total amount is not equal create a exception table line containing the Contract number and SUMmarized total. How can I get these ...

we loaded the files in MSSQL using DataStage. In AuditStage we want to compare the content of the fields. We have 2 files containing Contract Nbr, Asset Nbr, Invoice Nbr, Invoice Amount 1. We want to compare the total invoice amount per contract between the 2 files and if the total amount is not equ...

Good idea. I will try to compare the files using DataStage. Thanks for your answer. :? It's probably easier to do in a DataStage parallel job, using one of the change detection/capture stages. AuditStage, like ProfileStage, is really about determining what's in a file, not about comparing two files,...

Hi all, can anyone tell me if it's possible to compare txt files using audit stage. I know it is possible when loading these files into a database (using data stage) and afterwards use these tables in audit stage as input. But before doing this I want to know if the inputfiles are correct. When I cr...