Just study the Transformation Guide for PowerCenter. Look at the chapter about the Lookup Transformation, sub-chapter Multiple-Match Lookup.
This link is closer to my design and requirements however I got a error that looks like a software bug.
TE_7017 Internal error. Failed to initialize transformation [Lookup]. Contact Informatica Global Customer Support.
I found this - 357889 - tried adding alias to my query and removed caps still no luck. But thanks for the link!
Please try the steps to add a custom property at session level:
Open Workflow Manager.
Double click on session > 'Config Object' tab.
Add the property "lookupOverrideParsingSetting = 2" in Custom Properties under Advanced section.
If you are using Oracle hints, make sure there is a space before "/*" and a space after "*/"
Mine is an IICS, cloud based data integration platform. I am unable to access workflow settings or parameters related to that. Is there an add-on bundle that could help get access to session/workflow manager like settings?
Join something like below.
csv.date between oracle.startDate and oracle.enddate
then get the fields
To put in simple since your day dim is one time population I would go with csv dump into data base table and then do a join with oracle table.
Try to see the simplest way and get it done for one time tasks.