I have 2 tables in SQL Server that I must combine into 1 in Oracle.
Simple example:
Tab1 has col1, col2.
Tab2 has col3, col4, col5.
Tab2 is a lookup table. For every record in Tab1, I need to see if there is a record in Tab2 and get col4 and col5. The join is Tab1.col1 = Tab2.col3. The fields have different names. But I want my output record to be Tab1.col2, Tab2.col4 and Tab2.col5.
I am trying with Joiners LookupJoin and DBJoin. But I don't see anywhere to tell them that Tab1.col1 = Tab2.col3.
Thanks,
Scott
Simple example:
Tab1 has col1, col2.
Tab2 has col3, col4, col5.
Tab2 is a lookup table. For every record in Tab1, I need to see if there is a record in Tab2 and get col4 and col5. The join is Tab1.col1 = Tab2.col3. The fields have different names. But I want my output record to be Tab1.col2, Tab2.col4 and Tab2.col5.
I am trying with Joiners LookupJoin and DBJoin. But I don't see anywhere to tell them that Tab1.col1 = Tab2.col3.
Thanks,
Scott
-
Your example leads to use of HashJoin (probably better) or MergeJoin. It allows defining the "join" formula and also re-mapping two inputs onto single output record including renaming fields.
See examples supplied with CloverETL Designer, one of them shows various joiners in action.
Also, see Clover video tutorial, section Joining data from multiple sources and Aggregating.
If you really want to use lookups for your case, then look at Lookups section of Clover video tutorial.
Please sign in to leave a comment.
Comments 1