Join on subset of data
Posted: Wed Jul 30, 2014 8:32 am
Hi I have a requirement to join a subset of data. Below is the design
Flat file
|
|
Oracle------>LKP------>DS
Example I have to join on ID (present in oracle and Flat File)
Values for ID in Oracle Values in Flat file
123 3
456 5
we need to get the two rwos in the output, Subset of data in falt file should match with the data in oracle.
Note: Above was an example and I need to implement for large number of records.
Will I be able to achieve this in Datastage? if its a table in the refrence then I can use substr and instr to achive my requirement.
Flat file
|
|
Oracle------>LKP------>DS
Example I have to join on ID (present in oracle and Flat File)
Values for ID in Oracle Values in Flat file
123 3
456 5
we need to get the two rwos in the output, Subset of data in falt file should match with the data in oracle.
Note: Above was an example and I need to implement for large number of records.
Will I be able to achieve this in Datastage? if its a table in the refrence then I can use substr and instr to achive my requirement.