Completed the exercise in 3 steps.
Step 1: Combining Data from data sources
The data from data sources has to be combined and then unique of the set has to be taken (Except annual transaction field).
Step 2: Extract text to column user detail and using select tool, fix the data fields name and type be joined with step 1 fields.
Step 3: Join using step 1 and step 2 data.
Completed Practice Exercise 2