Is it possible to combine two heterogenous sources and load into one particular target. If so How using TPT?
Ex: I'm combining data from Oracle and DB2 and loading into one Teradata Table.
though we know Union All supports, but what other things like left join exists fot that
In a TPT script there's only support for UNION ALL to combine multiple data streams.
Of course you might load both sources independently in a staging table and then perform the outer join.