Archives of the TeradataForum

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

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

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>>