I am trying to use 3 tier architecture where i use 3 apps for Extraction, transformation and loading. in that i created a model without any synthetic keys in the data model, however i am having many issues where i am having null values and relationship issues with different fields, for e.g. store name is not returning any budget value even though the net value of the budget overall is returning properly. i hope i was clear. I am having issues even with successful model creation, there are some faulty connections.
