[resolved] lookup Slowly Changing Dimension table

[Anonymous]

Hi
Is there any simple way to lookup in tMap a Slowly Changing Dimension table ?
In my screenshot you can see simple fact table, and for each row I need to get its relevant description.
How can I implement in the lookup a "between" connection ? 

The lookup let me to do just "equal to" condition.(and not less than or greater than)
[font=Verdana, sans-serif]the SCD table has :id,from_date,to_date,value[/font]
[font=Verdana, sans-serif]the fact table has:id,date,value_to_find[/font]

[Anonymous]

Hi,
Thank you for your post! We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Note: Screenshots works only if you drag&drop the image directly in the editor window. 

Best regards
Sabrina

[Anonymous]

Hi
I've attached screenshot of both the tables data and the tMap.
How can I get the relevant product_desc ?

[gorotman · Accepted solution]

hi,
look here: http://community.talend.com:80/t5/Talend-Tech-Internal/tMomInput-MQ-Server-Websphere-MQ-Cannot-set-q..., it may help

bye

[Anonymous]

It helped a lot
Thanks