I have source data:
CC (country code)|SC (state code)
USA|IL
USA|IL
USA|NY
USA|NY
USA|TX
USA|TX
Reference data:
SC|DESCRIPTION
IL|ILLINOIS
TX|TEXAS
NY|NEWYORK
NY|NEW-YORK
Code: Select all
reference (sequential_file)
>>> Inner join (on key SC)>>>>output(sequential_file)
source(sequential_file)
Out put :
CC|SC|DESCRIPTION
Inner join:
Code: Select all
Inner transfers records from input data sets whose key columns contain equal values to the output data set. Records whose key columns do not contain equal values are dropped
Thank you