Hi Paul,

It's true that I could simply drop my audit table and log all my auditing in my various dimension and fact tables but that would not be according

to my assignment I'm afraid. I would like to make a separate table that contains all my auditing.

It might work as a last resort if all else fails however.

I'm not entirely sure how your solution with CreatedOn and UpdatedOn works. Are you saying I should create the columns inside the package?

And would I then have to create this on every dimension table I'm loading, since I am auditing every dimension table?

I wouldn't mind doing that, I just want to make sure I understand your solution.

I appreciate the help!

// Daniel