Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

In real time how do u know join or keep or concatenate tables?

kindly anyone explain me about what scenario we use to combine tables in what case?

1 Reply
Gysbert_Wassenaar

You combine tables if you must do so because

  • you need to do calculations that require fields from several source tables to be in one table
  • you experience performance problems with the current data model that can be solved by combining several tables and so create a more compact data model that's closer to a star schema data model.

talk is cheap, supply exceeds demand