PowerCenter
- PowerCenter 10.5
- All Products
<TablePair> Name = "Joined_MYVIEW_FACTORDERS" Description = "Joined MYVIEW-FACTORDERS" ExternalID = "" <TableA> Name = "SQLView_470" WhereClause = "" WhereClauseDSQ = false InDB = false <TableB> Name = "pc_repository/dvo_demo/Targets/factOrders" Connection = "dvo_demo_connection" WhereClause = "" WhereClauseDSQ = false InDB = false <Join> ColumnA = "MyID" ColumnB = "LineID" ColumnA = "MyCurrency" ColumnB = "CurrencyName" <TestCase> TestType = "VALUE" ColumnA = "MyCurrency" ColumnB = "CurrencyName" Operator = "=" Comments = "" CaseInsensitive = false TrimRightWhitespace = true TreatNullsEqual = true <TestCase> TestType = "AGG" Aggregate = "SUM" <ExpressionA> Expression = "if(MyID>10,10,MyID)" Datatype = "integer" Precision = 10 Scale = 0 ColumnB = "LineID" Operator = "=" Comments = "" CaseInsensitive = false TrimRightWhitespace = false TreatNullsEqual = true