Multiple choice technology

How do you establish a primary key-foreign key relationship between two source definitions in PowerCenter when that relationship does not currently exist between the tables in the database?

  1. Use the Source Analyzer to create the primary key-foreign key relationship and save the repository.

  2. Use the Source Analyzer to create the primary key-foreign key relationship and run the appropriate SQL statement on the database tables.

  3. Use the Source Analyzer to create the primary key-foreign key relationship and save the repository. Open the SQL Editor in all Source Qualifier transformations that join data from these two source definitions and regenerate the join statement

  4. Use the Source Analyzer to create the primary key-foreign key relationship and save the repository. Open the SQL Editor in all Source Qualifier transformations that join data from these two source definitions, generate the join statement, and modify the j
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

You can create logical primary key-foreign key relationships in the repository metadata using Source Analyzer. These relationships exist only in PowerCenter's metadata and don't require database changes. They help with join optimization and data lineage tracking.

Keep practicing — related questions