Very common best practices:

- never use *, always select and the columns you need. Not only in OLE_SRC, everywhere. (e.g. lookup component)

Limit the results of the queries with appropriate where clauses.

- avoid using blocking components

- never use the build-in slowly changing dimensions wizard

- double check your queries for cartesian products

- maintain documentation. The person after you wants to understand your code too.