Archives of the TeradataForum

Message Posted: Tue, 14 Sep 2004 @ 12:52:19 GMT

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

Narayan

Sound like you are having a bad day!

If you do not have a current backup (and this happens more often than not!) you may want to load the latest backup that you have and then reload the data from that point forward.

There is not much that can be done if the data is not backed up.

It is not resident within the warehouse so you have to get it into the warehouse using the same process that got it there in the first place.

Perhaps you can share with us what has happened so we can better assist you.

Questions that I have...

How is the data loaded?

What happened to the data?

Did it get deleted/dropped by accident? If so let the right people know so it can be managed. (nobody likes surprises!)

How current is the backup?

Do you use staging tables that have the data?

Do you have an archive area in the warehouse that would enable you to load the data faster?

I hope these questions assist you in resolving this issue...

Best of luck and keep us posted...

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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