Regarding mapping and effort estimation
2 posters
Page 1 of 1
Regarding mapping and effort estimation
Hi,
I'm a ETL developer for past 2 years and 2 months. I always have this questions. Please help me to appreciate
1) Whose responsibility is it to give the source to target mapping. Is it etl developer responsibility or a data modeler or designer responsibility?. Most of the time in my work, etl developer is pushed to take this up and validate the mapping with the business users. I found it very difficult to do it along with the etl job. Is it how it was done? Are there any predefined roles and responsibility matrix?
2) How to estimate the mapping effort while your have lot of unknown's? Lot of time I gave a estimates based on what we think. But when there is new data pattern, altogether it requires addition effort and was forced to work late. Please guide
Many Thanks
San
I'm a ETL developer for past 2 years and 2 months. I always have this questions. Please help me to appreciate
1) Whose responsibility is it to give the source to target mapping. Is it etl developer responsibility or a data modeler or designer responsibility?. Most of the time in my work, etl developer is pushed to take this up and validate the mapping with the business users. I found it very difficult to do it along with the etl job. Is it how it was done? Are there any predefined roles and responsibility matrix?
2) How to estimate the mapping effort while your have lot of unknown's? Lot of time I gave a estimates based on what we think. But when there is new data pattern, altogether it requires addition effort and was forced to work late. Please guide
Many Thanks
San
sanmur- Posts : 1
Join date : 2011-01-03
Re: Regarding mapping and effort estimation
Generally mapping specs are worked out by a business analyst and an ETL architect. It is not a good idea to have the developer also write the specs.
If there are a lot of unknowns and you need to give an estimate, document your understanding of the work you are estimating and list risks based on the unknowns. Make it clear that the work effort may change as new information is uncovered. As issues arise, document them and provide a estimate to resolve the issue.
If there are a lot of unknowns and you need to give an estimate, document your understanding of the work you are estimating and list risks based on the unknowns. Make it clear that the work effort may change as new information is uncovered. As issues arise, document them and provide a estimate to resolve the issue.
Similar topics
» Estimating star schema & ETL effort
» DATA MAPPING
» Mapping heterogeneous attributes
» ETL Testing coverage
» Can a Bridge Table also be used for mapping?
» DATA MAPPING
» Mapping heterogeneous attributes
» ETL Testing coverage
» Can a Bridge Table also be used for mapping?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|