how to generate sequece number in an existing table
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]

Answer Question   |  July 21, 2008  4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation