Work Catalog database is the loation of any temporary ODI objects (eg C$, J$, I$ tables etc)The temp tables are used for a number of things, remember that at this point in the Topology - ODI Doesnt know if your SQL Server connection is a source or a target, so it wants all the details just in case. Reasons for Temp tables on source might be :
== I am using a read only user to read the data. How ODI is creating temporary objects in SQL server. My work and master Repository is in Oracle database.
Work schema is the owner of the database (Work Catalog) value - again , typically dbo.Kind of - IIRC any user in the sysadmin role that creates objects have those objects created as dbo by default.
== is dbo a user like sys in oracle???