Saturday, November 17, 2007

Join two relational sources

A user desires to join two relational sources with a single Source Qualifier. The sources and the Source Qualifier have been correctly imported into the mapping. Next, she must establish a primary / foreign key relationship between two ports in the source definitions. Assuming that the relationship does not currently exist on the database server, what are the required steps to do this?

Choose Answer

(A)
Use the Source Analyzer to establish the primary / foreign key relationship and save the repository.
(B)
Use the Source Analyzer to establish the primary / foreign key relationship, save the repository, and run the appropriate SQL statement on the database tables to create the actual primary / foreign key relationship.
(C)
Use the Source Analyzer to establish the primary / foreign key relationship, open the SQL Editor in the Source Qualifier and generate the join statement, modify the join statement if required, and save the repository.
(D)
Use the Source Analyzer to establish the primary / foreign key relationship, regenerate the Source Qualifier SQL using the SQL Editor, press the Okay button, and save the repository.

No comments: