Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks for your comments.
Thanks for your answer. But see, in the same job, it works just by making the Time Dimension the main flow and the Orders table the lookup. The result is what I expect, so joining through the Date type columns works and there are orders on that date.
What I would like to do: given an Order find the respective date in the Dimension table to get attributes related to the date.
What's working: Given a date find the Orders for that date.
@NelsonTalend,is it left outer join or inner join you have used tMap, and are you taking inner join rejects?