I have a question about how to create the optimal data model for the following situation
I have 3 tables (A,B,C) that contain various columns. "A.ColA" , "B.ColB" and "C.ColC" are a lookup value codes. All lookup value codes and their descriptions are stored in a fourth table called "Lookups" and has the following columns
"Lookups.TableName" (values are A, B, C) ; "Lookups.ColName" (values are ColA, ColB, ColC) ; "Lookups.Desc" (values are ColADesc, ColBDec, ColCDesc)
How can I load these tables to link the lookup value codes to the appropriate lookup code description?
Is generic load the right approach ? Any assistance would be appreciated.
