IA Data Quality Rules

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

Are you generating the same unique IDs for the rules, and thereby overwriting rows in your table?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ktrogers
Participant
Posts: 8
Joined: Tue Sep 27, 2016 9:17 am
Location: Albuquerque, NM

Post by ktrogers »

When you say unique ID's what are you referring to? Each rule has a unique name. When selecting the data to be stored in the Name-User table, I am selecting SystemDate, RuleExecutableName, RuleMetOrNotMet, then the key to the table and the field being analyzed.

I do not see on any of the screen setting the unique ID.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Did you select 'append' for them all, or are some 'create'? You need to make sure you run the 'create' one first...
Regards,
Robert
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Did you select 'append' for them all, or are some 'create'? You need to make sure you run the 'create' one first...
Regards,
Robert
ktrogers
Participant
Posts: 8
Joined: Tue Sep 27, 2016 9:17 am
Location: Albuquerque, NM

Post by ktrogers »

All the rules are using 'Append'
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Post by truenorth »

Go to Project Properties and check your settings for purging rule output tables.
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Post Reply