topic Re: Loading Fact Table with many lookups in Talend Studio

Loading Fact Table with many lookups

Anonymous — Sat, 16 Nov 2024 06:17:41 GMT

I Have a problem with loading my fact table. i have 3 Dimensions and I am using them as look ups. To run the job its taking long and when its passing through the mappings its not inserting rows into the fact table.

Can Someone please assist me.

Re: Loading Fact Table with many lookups

manodwhb — Wed, 20 Mar 2019 09:52:31 GMT

@Shriya ,since you were using innerjoin in tmap,are you sure do you have matched records between dim tables and source table? and if you are sure that there is matched data then you might did the lookup on wrong column.

Re: Loading Fact Table with many lookups

Anonymous — Wed, 20 Mar 2019 09:57:03 GMT

Must I change the joins?

Re: Loading Fact Table with many lookups

manodwhb — Wed, 20 Mar 2019 10:07:29 GMT

@Shriya ,you need to verify the data between TbiVideo and with dim tables.since the join columns may not have matching data. you need to verify the data and specify the join.

Re: Loading Fact Table with many lookups

manodwhb — Fri, 22 Mar 2019 07:54:50 GMT

@Shriya ,still do you have this issue?