I am new to talend and I am trying to load fact table of daily sales between date range. I am using calendar table which is filter for 2 yrs only and I am joining both tables in tmap
so when job runs my job reads calendar table lookup first and then it reads the full fact table rather reading just the records between those two date
any help that how can avoid that so my job only read fact table between calendar date range
I have a sales fact table and calendar table,please check the attachment, all i want is to filter my fact table with my calendar table as calendar table is filtered for last 3 yrs.
at the moment my job is reading full fact sale table before filtering and due to this it takes ages
Joining tables on Oracle side is probably the best solution to avoid reading unecessary rows from sales table. On other words, rewrite your select query (maybe having a single query to retrieve information from both tables).
