DSXchange

I don't think REGEX would do the job, because I still need to test the equality between the two values. However, I came up with a solution: tostring(A, '%f24.2') = tostring(B * (1 - C), '%f24.2') Why .2? I decided to loosen the rule because the calculation and the resulting rounding might do funny t...

I have a rule that says A must be B*(1-C). Problem is A is coming from a table, a decimal(21,3) field. But the calculation is coded in the rule and has no rounding. So I'm getting rule violations of 0.633 versus 0.633012. So I need to round the calculation to 3 decimal places. I found documentation ...

Yes, I turned on all events, status and task runs. What's weird is that I turn on the box for "Common Elements" and "Information Analyzer" - basically turning on ALL boxes, I save, get the message that the View was saved successfully, but both Common Elements and Information Anal...

Thank you for this, Robert!

I just created a view. Meanwhile, if I had a schedule to run rules already going BEFORE I created this view, would I be able to edit that schedule? Or will this new view only see new schedules henceforth? So far I have not found the schedule I have already going.

When I create a rule or rule set report, IA does not prompt for which run I want IA to report. For example if I run the same rule on these three days - January 18, 19 and 20 - when I create a new report, IA does not ask which of the three runs it should report on. So which one does it pick up? The l...

Using IA's facility - Run, Schedule, set options, Submit - I have scheduled 45 rules and rule sets to run daily. They have been running, but I need to 'unplug' a couple of rules so they do not run anymore. For the life of me, I cannot see anywhere the set schedule so I could edit it. I would appreci...

Not a bad choice. In fact, my project has used it in the past. I'm just looking for other good alternatives.

Is there an echo here? Hehe.

Thanks, Julio. You're always a wealth of information, and always willing to share.

Thanks, Ray. I'm more interested in the format the results are disseminated. PDF? HTML? CSV? How about creating user accounts to business and having them log in to IA and see the results for themselves?

Advantages/disadvantages of each method?

Are virtual tables one-time snapshots? In other words, if I create one today and next week the data changes, is my virtual table out-of-date? Or is it like a view, such that the changes are reflected and therefore the data is always live?

In v8.7, after running rules. what are the options to distribute the results, i.e., how is the list of rule violations communicated to business? What are the best practices?

Thanks in advance.

Thanks, Ray.

Thanks, Ray.

Hi, all. I'm new to v11.x.

I'm wondering if user-named output tables - simple or advanced - can be accessed outside of IA. For example, can I query them in SQL? Or can they be used as an input table in DataStage?

Thanks in advance.

How do I copy/import IA 11.3 jobs into 8.7 installation?

Thanks in advance.