Special Cases

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
  • When a procedure is created by a Data Explorer analysis, the profiled columns are associated equally with each of the output tables, even though all columns will typically not have been profiled in each of them.
  • When a procedure advertises its output and an output name containing a quote or double quote is given in the procedure call, the object won't be advertised correctly.
    The following cases do not pertain to the Teradata Profiler product.
  • When a procedure that advertises its output contains a String or Text parameter, the actual call advertised reflects the parameter evaluated as a string (for example, USER might become 'TWM').
  • When calling a stored procedure that advertises output, passing a literal parameter that contains an embedded quote or double quote will typically result in either a blank field or missing rows in the advertise metadata. For example, the string 'That''s all right' or the list of values '''A'', ''B'', ''C''' when passed as a parameter would not be seen in the advertised metadata.
  • When a procedure advertises its output, numeric parameters are placed in quotes in the metadata. The quoted numbers work, but aren't needed when called.
    Advertising a procedure that contains a combined ADS and Score will delete any preceding entry for an ADS with the same name as the combined ADS at the time the procedure is created (even before executing it).
  • When Refresh creates a stored procedure and either advertise output or always advertise is requested, the only output advertised in the procedure is the output of the analysis being refreshed and an ADS preceding a score, if applicable. If neither advertise output nor always advertise is requested, no output is advertised by the procedure.
  • When Refresh does not create a stored procedure, the advertise output option overrides any setting on the analysis being refreshed and an ADS preceding a score if applicable, but not on other analyses in the chain. Of course, when always advertise is requested, all refreshed output is advertised.