Archives of the TeradataForum
Message Posted: Thu, 07 Feb 2008 @ 17:10:16 GMT
Thanks for your response.
- By reading the same data more than once I mean we query lets say table A and loads 10 target tables. But we don't have a single job that reads the data and loads into targets tables, we have 10 different jobs. So basically we are querying the same data 10 times.
- We are using FSLDM
- The link that you had sent, we do have cases like those in generating keys. And yes that takes a very long time. We have like 7 columns that form the UPI. But if we removes them then would it not affect the join performance?
- From staging to end tables we use only MLOADs. So basically its MLOADS all the way.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|