What should the data architect do to resolve this issue?
A. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
B. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
C. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
Answer:A
What should the data architect do to resolve this issue?
A. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD B. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field C. Open the data manager, split the Customers table, and associate both tables on CustomerlD field D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table