Im using combination lookup and update step in ETL scripts to build the star schema. I have a pre-populated date dimension along with few views(mysql) derived from it to look up and replace the stream data.

Now my problem is when ever I use the view table in the lookup and combination step, transformation get failed with the "Error looking up row in database". But if I use the original date dimension table same transformation works without any issues.

Do I needs to put any extra care to handle the data from view to work with combination lookup step ?

Please advice.

Thank you,