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.
Does IA convert tasks into SQL and execute?
Does IA convert tasks into SQL and execute?
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Sr Consultant, Data Quality
San Antonio TX
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.