PASSING ROWID OF ROW FROM SRC TO TGT TABLES

[hubud]

At present my mapping passes rows from src to tgt tables, the target table has a trigger that then deletes the processed row from the source as it enters the target table. This ensures that the source table is tidied up during the session.
At present a pre-session create_index procedure runs on a sequence column in the source table that is used to delete by the trigger on the target table. This is used extensively on our datamart. A better way, to avoid the relatively slow index creation on large tables, would be to reference the rowid of the source row. I can't seem to find a way to pass the rowid in the mapping as when I import the table I don't get the option to choose the rowid.

Does anyone know a way to do this?

cheers

simmo

 

[blom0344]

Totally wildly suggested:

How about creating a view on your source that has the row-id as extra and using this as the source?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[hubud]

Can't tell if there's sarcasm in there or not, however having looked into it.. If you add the rowid to the source definition having imported the source qualifier will generate the sql to pull this information without having to create the view.


cheers

simmo

 

[blom0344]

????????????????????

Sure don't expect any reactions from me anymore......

T. Blom
Information analyst
tbl@shimano-eu.com