Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading Fact Table with many lookups

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.

Labels (3)
4 Replies
manodwhb
Champion II
Champion II

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

Anonymous
Not applicable
Author

Must I change the joins?

manodwhb
Champion II
Champion II

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

manodwhb
Champion II
Champion II

@Shriya ,still do you have this issue?