-
1. Re: connected lookup transformation help
Syed Aziz Feb 5, 2020 11:36 AM (in response to Pavan Narayanan)1 of 1 people found this helpfulHello Pavan,
KB 15174 is useful in Handling Multiple Matches from Lookups in PowerCenter mappings.
Best regards,
Syed
-
2. Re: connected lookup transformation help
Nico Heinze Feb 6, 2020 1:53 PM (in response to Syed Aziz)Just study the Transformation Guide for PowerCenter. Look at the chapter about the Lookup Transformation, sub-chapter Multiple-Match Lookup.
Regards,
Nico
-
3. Re: connected lookup transformation help
Pavan Narayanan Feb 14, 2020 12:23 PM (in response to Syed Aziz)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!
-
4. Re: connected lookup transformation help
Syed Aziz Feb 14, 2020 1:03 PM (in response to Pavan Narayanan)1 of 1 people found this helpfulHello Pavan,
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 "*/"
Best regards,
Syed
-
5. Re: connected lookup transformation help
Pavan Narayanan Feb 14, 2020 1:33 PM (in response to Syed Aziz)Hi Syed,
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?
-
6. Re: connected lookup transformation help
Srini Veeravalli Feb 14, 2020 1:59 PM (in response to Pavan Narayanan)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.