Multiple choice technology

If we have 684 tables to join then how many joiners we need ?

  1. 342

  2. 2

  3. 683

  4. We cannot join these many tables in joiner
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To join n tables, you need n-1 join operations. This is a fundamental database concept - each join combines two result sets, so joining 684 tables requires 683 joins/joiners. Option A (342) would be half, which is incorrect. Option D is wrong because Informatica can handle large numbers of joins through multiple Joiner transformations.

AI explanation

To join 684 tables, we need to understand how many joiners are required. Each joiner can join two tables at a time.

Since each joiner can join two tables, we can divide the total number of tables by 2 to determine the number of joiners required.

684 tables / 2 = 342 joiners

Therefore, the correct answer is A) 342.

Keep practicing — related questions