My Source records are unique records. But my reference records contain multiple records for the same key. Now, i want output with multiple records.
Source record
AA 12B 2
BB 23Y 3
Reference recrods
AA 12B U-
AA 12B Y-
BB 23Y I+
BB 23Y O-
Output required
AA 12B U- 2
AA 12B Y- 2
BB 23Y I+ 3
BB 23Y O- 3
My database is oracle. So, i tried to create a hash file for the reference records but hash file only stored unique records.
Can somebody help me in resolving this issue.
Thanks!!