Hi,
Yes, you can specify your own ordering based on a column in the staging table. To do this, you can add an additional column to the staging table that specifies the order in which the rows should be transformed. You can then use this column as a sort order in your Transform Map to ensure that the rows are transformed in the correct order.
Here are the steps you can follow to specify your own ordering based on a column in the staging table:
Add a new column to your staging table that will be used to specify the order in which the rows should be transformed. For example, you could add a column named "Order" that contains a numeric value for each row, indicating its position in the transformation order.
Populate the "Order" column in the staging table with the appropriate values to specify the transformation order. You can do this manually or by using a script.
In your Transform Map, add a sort order that uses the "Order" column to order the rows. To do this, go to the "Mapping" tab of your Transform Map and click the "Advanced" button. In the "Order By" section, add the "Order" column and select the "Ascending" or "Descending" sort direction as appropriate.
Save your Transform Map and test the transformation to ensure that the rows are transformed in the correct order.
By adding an additional column to your staging table and using it as a sort order in your Transform Map, you can ensure that the rows are transformed in the correct order, even if they depend on one another.
Thanks,
Rahul Kumar
If my response helped please mark it correct and close the thread.
Thanks,
Rahul Kumar
