Timestamp as key field on ODS
I have defined as key, 0date and 0time fields on my ODS so that I get unique records. However, on loading data to the ODS, I still get duplicate 0date and 0time entries. I am populating the 0date with sysdatum and 0time with system local time at runtime within the update rules. However, for some reason, most of the records are being populated with the same 0date and 0time value. What is the best method for ensuring a unique timestamp for each record and if this cannot be achieved, can someone tell me how to generate a unique sequence?