Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Studio - filtering one table in mapping based on a value in another table

I currently have a Mapping that filters incoming data pulling from an external source based on sysdate-3. In the unlikely event that we'd be down for more than 3 days, my team is working on adjusting the mapping to reference the last time the data was captured and looking a day before as the new replacement.
For right now, I'm trying to figure out how to filter a table (ex. TABLE_A by TABLE_A.LASTMODDIFIEDDATE) based on a date stored in a second table (TABLE_B). TABLE_B has a row for every extracted table, and the timestamp for when it was last successfully extracted. So, I want to filter the output basically like TABLE_A.LASTMODIFIEDDATE greater than or equal to TABLE_B.LAST_EXTRACT WHERE TABLENAME = X.
I have tried a bunch of things but I'm not certain how to make the mapping filter one table by another. There is no direct way to join these two tables. Any assistance would be helpful.
ODI Studio 12.2.1

Comments

JeffJon
Have you tried updating the configuration setting for the amount of time that the message is displayed?
LarryR
James, I don't know if thiere is a way to promote your Info Bar message, but given that it may not be possible, would a pop-up window work better in this situation?
783124
Yes this is a good solution, or at least it would be if the message window were left on top, instead of the modal popup and the main window taking centre-stage again a split second later! Is there a way to keep this message window on top?

Another possible solution - do you know if it would be possible to add the message to the "LoadOptMethodVal" Option of the adapter, by passing in the message string? It would be great if the message could feature in the Target System Load modal popup. I suspect not, but it would be ideal, since this would then give the user the option of whether to proceed with the data load or not. I tried modifying the Description field, but this does not appear to feature in the modal popup.
1 - 3

Post Details

Added on Mar 7 2022
#business-intelligence-applications, #data-integrator, #mapping, #odi, #system-management-and-integration
3 comments
1,548 views