Multiple choice technology

Can we update target without primary key ?

  1. Yes

  2. No

  3. May be

  4. Not sure
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DataStage requires key columns (typically primary keys) to identify which rows to update in the target. Without keys defined, the update operation cannot determine which specific rows should be modified.

AI explanation

To answer this question, we need to understand the concept of updating a target without a primary key.

Option A) Yes - This option is incorrect. In most cases, a primary key is required to uniquely identify each row in a table. Without a primary key, it becomes difficult to identify the specific row that needs to be updated.

Option B) No - This option is correct. Without a primary key or a unique identifier, it is not possible to update a target reliably. The primary key ensures that each row in a table has a unique identifier, allowing for precise updates.

Option C) Maybe - This option is incorrect. The presence of a primary key is essential for reliable updates. Without it, there is a risk of updating multiple rows or not updating the intended row at all.

Option D) Not sure - This option is incorrect. The correct answer is B, as explained above.

The correct answer is B. Without a primary key, it is not possible to update a target reliably.

Keep practicing — related questions