Search found 2 matches

by fit_dsx
Wed Jan 30, 2013 11:16 am
Forum: IBM QualityStage
Topic: Advice on joining on 'unexact' match
Replies: 8
Views: 6743

Thaks for the reply...Sorry..I am not sure if are you restating my problem statement or giving me a solution? My problem is how to 'standardize' the invoice columns so that a match can be made between the two systems The 'REAL' invoice numbers are 'contained' within the LEDGER SYSTEM column. There a...
by fit_dsx
Wed Jan 30, 2013 8:36 am
Forum: IBM QualityStage
Topic: Advice on joining on 'unexact' match
Replies: 8
Views: 6743

Advice on joining on 'unexact' match

Need some advice. I don't know if I should be using QualityStage (for which I have no experiece) or DataStage or just down and dirty SQL. Problem: I have invoice numbers in a column in a table from the AR System. I have invoice numbers in a a column from the ledger system. I need to be able to join ...