|Customer_Name||Branch Name||Branch_ID||ItemGroup||Fiscal Year|
Above tables are my table structure.I want to do a data model for this.Need you help
2 table (i.e) Business plan and fact table is in separate table.
I tried many ways it generates synthetic key or circular reference.Need your help
First, get your facts in the middle. Then try to link all your fields to this fact table.
Every name that is then double in your tables, that is causing synthetic keys or circular references, rename them!
For example: Branch name from BusinessPlan_Fact -> Branch name as BusinessPlan.BranchName.
This way you don't have any duplicates.
Thanks for your response
Yeah that's the issue i'm facing
but for business plan fact i want to analyse by itemgroup and branch name.
Because i want to compare business plan facts with fact table facts.
If i go with your step(i.e Concatenate 2 fact tables).the following scenario happens
I'm using Itemgroup wise Potential it won't works.because in Fact table itemcode is linked
I get the problem. For this you can left join your Item table:
Left Join(Fact) Load distinct ItemCode ItemGroup From [YourSource](qvd);
This way you won't have this problem.