Lookup Transformation vs Join

Hi ,

Just a bit introduction about me . I am SQL developer , also part of the [SSIS]ETL process too but not an expert level. At present i am part of one of the DataWarehouse project , While populating fact we need to join with dimensional table to populate some of the dimensional attributes . This job can be done well with lookup transformation , but another way we can use by joining dimensional table in OLEDB Source in dataflow task.
Please comment on the approach if we are joining dimension table in OLEDB Source .?
Will there any performance improvement by joining this way?
Why lookup transformation for , any advantage ?

Lookup is good for small table like value and description Key value pair. But when there are many attribute associated with data then it make more sense to go for dimesion table and use that as a joining.

Any way in fact you should always keep the surrogate key of dimension table.

Most ETL tools will cache lookups in memory, so they tend to be much faster than joining as a source. In particular, when you are loading facts.