topic Re: FACT AND DIM TABLE in Talend Studio

FACT AND DIM TABLE

Anonymous — Mon, 06 May 2019 22:51:36 GMT

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

Re: FACT AND DIM TABLE

Anonymous — Tue, 07 May 2019 03:35:42 GMT

Hello @Ace50 ,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: FACT AND DIM TABLE

Anonymous — Tue, 07 May 2019 16:09:11 GMT

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

Capture.PNG

Re: FACT AND DIM TABLE

TRF — Tue, 07 May 2019 22:15:44 GMT

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).