Table Sequence in the DataStage

I Nav. I am using two key tables the Item ledger Entry and the item Value Entry tables. In the data-stage I use have calculated (lookup) fields in both tables, for example I calculate Cost from the Value Entry in the Item Ledger Entry, and calculate A Lot number from the Ledger Entry into the Value Entry. Both of these tables are used as fact tables in different Cubes. Currently I bring in the Value Entry ahead of the Item Ledger Entry. How can I then calculate values from the Item Entry into the value entry?

1 comment

Please sign in to leave a comment.