Souring data from multiple sources and combinedly loading the final table in TD(TPT)

Tools
Enthusiast

Souring data from multiple sources and combinedly loading the final table in TD(TPT)

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.

2 REPLIES
Enthusiast

Re: Souring data from multiple sources and combinedly loading the final table in TD(TPT)

though we know Union All supports, but what other things like left join exists fot that

Senior Apprentice

Re: Souring data from multiple sources and combinedly loading the final table in TD(TPT)

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.

Dieter