DSXchange

Hi,

Can anyone tell me in detail, what all factors need to be concerned for "Extract Requirements of Data". We need to start a new project. And right now in phase to discuss about Extract Requirements. We Would like not to miss any point to repent later on

Thank You

I recommend that you get some training/mentoring in ETL or research or read some books. This would help you far more than the quick fix you will get here! If you learn it and then apply it you will own it, but if we give it to you then you will have learned nothing.

There is a plethora of material on the web and in book stores regarding your very question.

Regards,

That question is of a very generic nature. Sounds like a process design question to me.
One thing that i really try to keep in mind while designing my process is to extract only the new/changed records from the source database based on a timestamp.
Design the extract to accept two parameters which will be used in the where predicate for my sql select.
My 2 cents.

tostay2003 wrote:Can anyone tell me in detail, what all factors need to be concerned for "Extract Requirements of Data".

There are some folks around who make a living doing exactly that. They tend to have titles like "business analyst", and produce documents called "source to target mapping" or, if you're lucky, "target from source mapping". Does your organization have any business analysts on staff who are allocated to this project? If not, you seriously ought to consider hiring one or two, and guaranteeing them access to your business's subject matter experts during their analysis phase.

You can find links to sites with these documents on www.olap.it I think Ganett had my favorite source to target documents. Not sure if they are on this site or where the exact link is for these documents.