I'm also thinking about transitioning from Oracle to Teradata, and one of the issues I'm worried about is the random number function in Teradata...mainly that it calculates a new value everytime it is run, whereas in Oracle it can be the same on repeated runs.
Is there any way to upload or transfer the Oracle random number function into Teradata?
Thanks for the help!
I guess you are refering to dbms_random?
I have some doubts that you can migrate this function to TD. Main issue is the parallel data distribution and parallel processing.
You clearly don't want to have a central maintained seed.
So alternative would be to initiallize this per vproc, which would still give you the problem that in case of sync scans the first row per SQL could be different even if you submit the same SQL twice.
What might work is to implement a pseudo random generator as UDF and you use the row input as seed - rowid would be best but can't be used any more. So you need to do it more complidated.
This would give you per row a different output number - still multiset tables would be an issue as same rows will get same output.