Praveen

• Aug 14th, 2005

 

Data modeller will provide the ETL developer, the tables that are to be extracted from various sources.

Andy

• Aug 23rd, 2005

 

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.

dvs

• Nov 5th, 2005

 

draw the inference if slowly changing dimension and based on the Type 1/2 or3  tables defined.