3 Tier architecture Issues

[thakurdagautam]

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.

[AshutoshBhumkar]

Hello,

I would suggest you to check following things.

1. Check format of Primary Keys and Column names (If Join or Concatenate is used).

2. Check executing parts of code in same or different app to check where the code is not working properly.

Thanks,

Ashutosh