Does IA convert tasks into SQL and execute?

[truenorth]

When IA conducts an analysis, say RI or data rule, does it execute an SQL code? If so, how does one view the SQL?

Reason I ask is that our DBA is interested in looking at the SQL and determining whether executing the SQL might hamper things in production.

[ray.wurlod]

IA does not work that way.

Conceptually the process can be explained in SQL terms, something like SELECT CAST(col1 AS VARCHAR), CAST(col2 AS VARCHAR), ... FROM table but it's really using ODBC API functions. You could, of course, start an ODBC trace to see what's happening.

The raw data are then dumped into the IADB which is used as the source for the acutal analyses, and the results thereof are stored in XMETA.

[tcj]

I would strongly suggest not profiling on a live production database. Profiling can easily bring a production database to its knees.

Best practice method is to run profiling on a copy of the production database.

Tim

[truenorth]

Thanks, Tim, Ray.