Not an original idea, more of a whole sale rip off of a post we found.
T = ((E * D * 5)+(S * C * 6)) * A + F
where
T = total no. of days to allow for implementation
E = no. of entities in physical model
D = data quality (D = 0.5 very clean, D = 1 medium
cleanliness, D = 1.5 dirty, a lot of work)
S = no. of source systems
C = complexity of transformations (C = 1 relatively simple,
C = 0.5 1 to 1 mapping, C = 2 complex, lookups required, derived data,
calculations)
A = automation factor (A = 1 ETL tool used, A = 1.6 manual
coding)
F = first time implementation, use of ETL (F = 0 many
implementations done, F = 20 small & flexible, F = 50 large development)
this estimates have been tried and proven from my project
management experience in projects implementing with Informatica as ETL tool.
try it and refine it at the end of each project.
No comments:
Post a Comment