I have 2 tables. like:
CCB_ID FixedRate DefaultRate
And another table(destination):
SC_ID CCB_ID DefaultRate
I need to fill this Scheduling table. So I made a relationship between the CCBudget and Scheduling on CCD_ID field. So this will get populated from the CCBudget.CCB_ID. So with respect to that Scheduling.CCB_ID i need to populate the DefaultRate from the CCBudget into Scheduling table.
Can anyone give me suggestion to solve this by using SQL DataGenerator.