Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Feb 2008 @ 17:10:16 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Reduce loading time
From:   OmerAl

Hello Victor,

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019