rajeshb121
Technical User
Hello,
I'm new to Data Stage, could any one tell me Using Data Stage Tool how to process multi DB2 Records for a Foreign Key. In Cobol-DB2 we can use CURSOR to Fetch Multiple Records for a Key (Foreign Key).
In Data Stage Tool how to process ?
Ex.
Table 1:
EmpNo Primary Key
EmpName
DeptNo Foreign Key
Table 2:
DeptNo Primary Key
EmpNo
DeptName
Under one Dept there can be Multiple Emp.
I'm new to Data Stage, could any one tell me Using Data Stage Tool how to process multi DB2 Records for a Foreign Key. In Cobol-DB2 we can use CURSOR to Fetch Multiple Records for a Key (Foreign Key).
In Data Stage Tool how to process ?
Ex.
Table 1:
EmpNo Primary Key
EmpName
DeptNo Foreign Key
Table 2:
DeptNo Primary Key
EmpNo
DeptName
Under one Dept there can be Multiple Emp.