This content has been marked as final. Show 3 replies
If you import a transaction table you may have keys imported in physical layer but when you going with warehouse table you may not have keys at database level, you define them using join in physical layer.1 person found this helpful
We have surrogate keys in dwh.
Hope this clear your doubt, if helps pls mark
So If the keys are not imported ,we need to create those in alias table as well as in the imported table(original table ).is it correct?
We cant to any changes on alias type objects in physical layer. You have to do changes in Table objects(original table ) and that will affect on Aliases. During the creation of joins keys are created, tool will prompt for the same.1 person found this helpful
Hope this helps, if helps pls mark as correct ;)