Recent content by PaulinaK

Hi all, We have an Oracle 8.1. db and a Server Model in Oracle Designer 6i. The model is pretty outdated and I need to bring it back in sync with actual db (db objects as well as administration objects such as users, roles, etc). I would not want to simply reverse-engineer the db into Oracle...

Hi All, I am new to Informatica and was wondering if anyone has any manuals/tutorial materials on PowerCenter 5, 6 or 7. We don't have the product installed yet, so I can't use online help. But need to get a good idea about how it all works. If anybody could help me out and send me...

Can anybody please tell me how standard Oracle 9i SOUNDEX will work with non-English names (say, Spanish)? Also, how does standard Oracle 9i SOUNDEX handle names with hyphens? Note: Please don't tell me about new/improved/custom-coded matching algorithms. I know one can code anything, if...

Thanks Mufasa. This is what I suspected based on common sense. Quick follow up question regarding the UPDATE transactions and their audit(while on this topic): does Oracle Audit feature let me clearly store/see old and new values, or do I have to dig through the DML statement to see the new...

Question: is it a good/bad idea to turn statement auditing on for all INSERTs, UPDATES, DELETEs on all tables? Purpose: we need to be able to go back and see who changed what data in the db. How much of an impact would it have on performance (overhead)? How much of a space issue would it be...