Let's say I have 2 views on database side ( Customer , Customer_LifeTime_Activity ) with following data :
Customer:
[c_id]
A
B
C
Customer_LifeTime_Activity:
[c_id], [value]
A 100
A 200
A 300
B 100
B 400
B 855
C 100
Extracts are generated from database views weekly. I use FastExport dump to file, and file import it's quicker then ODBC for Teradata. So in the end we have 2 calls of load utility :