Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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.
Must I change the joins?
@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.
@Shriya ,still do you have this issue?