DSXchange

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 create a new project in audit stage I am not able to define a flat file as input source. Any suggestions ?

Regards, DLLAND

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, until you get to analyzing for potential foreign key relationships.

Good idea. I will try to compare the files using DataStage. Thanks for your answer.

ray.wurlod wrote: 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, until you get to analyzing for potential foreign key relationships.