Saved Bookmarks
| 1. |
In A Joiner Transformation, You Should Specify The Source With Fewer Rows As The Master Source. Why? |
|
Answer» JOINER transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer ITERATIONS of the join comparison OCCUR, which SPEEDS the join process. Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process. |
|