Open Studio for Big Data
Open Studio for Data Integration
Open Studio for ESB
By default, without a Join set up, in each input table of the input area of the Map Editor, the All rows match model option is selected. This All rows option means that all the rows are loaded from the Lookup flow and searched against the Main flow.
The output corresponds to the Cartesian product of both table (or more tables if need be).