Acrien

• Nov 3rd, 2006

 

Informatica Sequence Generator:Maximum value reached at 2^(31) or 2.147 billion, and will automatically restart at 0. The sequence generator will calculate the max value in the column that you're adding to, and start with max+1 as nextval. ex: your emp table has 5 rows, with empid 1, 2, 3, 4, 5. supposedly the sequence generator will generate 6 the next time you insert. Which means it will avoid generating duplicates.This is also slower as it does not use Oracle built-in datatypes, BUT it does not require opening an ODBC handle, connect, return value from Oracle, then close ODBC for each row of data. Which makes this faster to run than a stored procedure transformation that returns a value from Oracle Sequence Generator (you can however build the seq. gen. into a trigger on insert).Oracle Sequence Generator:Faster in generating the number. Not sure about what power of 2 goes up to, but past trillions (999 trillion?). can be used in triggers so there is no need for a separate transformation inside your mapping. Does not check for duplicates.