Question
Compare etl & manual development?
Answers
ETL - The process of extracting data from multiple sources.(ex. flat files, XML, COBOL, SAP etc) is more simpler with the help of tools.
Manual - Loading the data other than flat files and oracle table need more effort.
ETL - High and clear visibility of logic.
Manual - complex and not so user friendly visibility of logic.
ETL - Contains Meta data and changes can be done easily.
Manual - No Meta data concept and changes needs more effort.
ETL- Error handling, log summary and load progress makes life easier for developer and maintainer.
Manual - need maximum effort from maintenance point of view.
ETL - Can handle Historic data very well.
Manual - as data grows the processing time degrades.
These are some differences b/w manual and ETL development.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q What is the significance behind 61st amendment of article 326 in 1989?
  • Q Who is the newly elected President of Amateur Kabaddi Federation of India (AKFI)?
  • Q Is it possible to perform stream operations in java 8 with a thread pool?
  • Q What are record groups ? Explain the types of record group.
  • Q Which union minister has launched North East Festival ‘North-East Calling’ in New Delhi?
  • Q Which shortcuts is used to bring up the import window?
  • Q What is the default value of "vbroker.agent.localfile" property?
  • Q What are your interests and hobbies?
  • Q Which is the octopus shaped lake of Kerala?
  • Q How do we assign row level security to users?
  • Q Describe static memory allocation and dynamic memory allocation?