How do you handle errors? Exception handlers?

Questions by upendarkm

Showing Answers 1 - 1 of 1 Answers

Jobin Joseph Veliyath

  • May 30th, 2012

The errors can be handled in different way, will list few of the methods which we can achieve via ETL

If it is a critical fact table (Merchandise, location and time (weekly)) then

Non-Critical Data - Foreign Key failure on item, those data can be deviate to a file or table (If we are using the table then we have to model the table in such a way that it can accommodate n number of foreign key data) and process it separately.

Critical Data - Foreign key failure is happened, there should be a process to get the unique foreign key and insert the missing records into the merchandise dimension table with a dummy value and then we should process the fact data immediately.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions