topic Re: [resolved] lookup Slowly Changing Dimension table in Talend Studio

[resolved] lookup Slowly Changing Dimension table

Anonymous — Mon, 05 Sep 2016 11:27:29 GMT

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]

Re: [resolved] lookup Slowly Changing Dimension table

Anonymous — Tue, 06 Sep 2016 04:35:35 GMT

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

Re: [resolved] lookup Slowly Changing Dimension table

Anonymous — Tue, 06 Sep 2016 08:12:07 GMT

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

Re: [resolved] lookup Slowly Changing Dimension table

gorotman — Tue, 06 Sep 2016 14:57:13 GMT

hi,
look here: http://community.talend.com:80/t5/Talend-Tech-Internal/tMomInput-MQ-Server-Websphere-MQ-Cannot-set-quot-Sleeping-time/m-p/4520#M21662, it may help

bye

Re: [resolved] lookup Slowly Changing Dimension table

Anonymous — Thu, 08 Sep 2016 07:15:34 GMT

It helped a lot
Thanks