I'm working a little bit in the datawarehouse again (by the way, is it two words or one?). A technical guy from Oracle showed up today to help us decide the best way to move forward on capturing changes. There were essentially 4 methods:
1. SQL and PL/SQL
2. Streams (CDC)
4. Logical Standby/Data Guard
As someone on the phone was talking, I started to wander...hmmm...what about some kind of pseudo column for that stored the last update (either INSERT or UPDATE) of a row?
Off the top of my head, I can think of rowid, rownum, and level. I'm sure there are others (feel free to comment).
Oracle, I'm sure, stores that information some where right?
I hadn't really given a thought as to the feasibility or the impact it might have, but that would make capturing changes a whole lot easier...