DSXchange

Hello,

I am wondering if anyone has successfully used the IA API to run column analysis?

I have used it successfully to run DQ rules and extract the results, but I am struggling to use it for running column analysis.

Here is the xml structure the api uses and the part I am not sure of is the "Column name" attribute.

How is structured in terms of schema.table.column?

<RunColumnAnalysis
analyzeColumnProperties="true"
captureFDResultsType="CAPTURE_N"
minCaptureSize="2500
maxFDCaptureSize="5000"
analyzeDataClasses="false">

<Column name="BANK.BANK1.*.*"/>
<Column name="BANK.BANK2.TABLE1.*"/>

<SampleOptions type="every_nth" size="1000" nthValue="10"/>
<Schedule startDate="2010-02-09T18:56:31+01:00"
runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10">
<ScheduleRepeat second="0" minute="0" hour="12"
dayOfMonth="*" month="*" dayOfWeek="?" year="*"/>
</Schedule>
</RunColumnAnalysis>

Many thanks

Bob.

Hi Bob,

It's database.schema.table.col, with anything able to be *

"BANK.BANK2.TABLE1.*"
means
BANK database
BANK2 schema
TABLE1 table
all columns

Here is a simple one I used:

<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name="Optim PFK">
<Tasks>
<RunColumnAnalysis>
<Column name="BANK1.PRD.CUSTOMERS.*"/>
</RunColumnAnalysis>
</Tasks>
</iaapi:Project>

Reference: http://www-01.ibm.com/support/knowledge ... rt_ca.html

Hi Robert,

Perfect!

Many thanks.

Bob.