Gurus,
I came across a typical requirement where the input is like-
TRANS FIRM
DEPT CUST
TRANS CUST
TRANS DEPT
FIRM CUST
& the expected Output is-
CUST
DEPT
FIRM
TRANS
This is basically a dependency list for processing the tables where
FIRM is feeding data to TRANS table
CUST is feeding data to DEPT table
CUST is feeding data to TRANS table
DEPT is feeding data to TRANS table
& CUST is feeding data to FIRM table.
Due to the feeding mechanism, the FIRM table should be available even before the TARNS is being processed, but since TRANS is depended upon CUST, CUST should be processed even before & likewise.
Finally the typical sequence of execution should be like-
CUST
DEPT
FIRM
TRANS
Appreciate your help in this regard