Join Condition in ETL

Ganesh_Naren

1.For Some scenarios we will join tables based on the between dates condition with out columns mapping

Eg select a.*,b.* from Table1 a , Table2 b where Date between date1 and date2

2.For Some scenarios we will join tables without any conditions

Eg select a.*,b.* from Table1 a , Table2 b

marcel_luthi

While having the feature would be awesome, a workaround is to add a JoinKey on both tables (constant), join on that key (basically doing a Cartesian product for the tables) and then apply filters that would replicate what you'd have specified in the regular ON clause of a SQL JOIN, you can Drop the Join Key as part of the column edits in the same Join Tile, this would do exactly what you describe in case 2.