SDET- QA Automation Techie

Software Testing Blog

  • Home
  • Training
    • Online
    • Self-Paced
  • Video Tutorials
  • Interview Skills
    • HR Interview Questions Videos
    • Domain Knowledge
  • Career Guidance
  • Home
  • Software Testing
    • Manual Testing Tutorials
    • Manual Testing Project
    • Manaul Testing FAQS
    • ISTQB
    • AGILE
  • Web Automation Testing
    • Java Programmng
    • Python Programmng
    • Selenium with Java
    • Selenium with Python
    • Robot Framework(Selenium with Python)
    • selenium with Cucumber
    • TestNG+IntelliJ
    • Mobile App Testing(Appium)
    • JMeter
  • API Automation Testing
    • Rest Assured API Testing (BDD)
    • Rest Assured API Testing (Java+ TestNG)
    • Robot Framework(Rest API Testing with Python)
    • Postman
    • SoapUI
    • API Testing(FAQ's)
  • SDET|DevOps
    • Continuos Integration
    • SDET Essentials
    • AWS For Testers
    • Docker
  • SQL
    • Oracle(SQL)
    • MySQL for Testers
    • NoSQL
  • Unix/Linux
    • UNIX TUTORIALS
    • Linux Shell Scripting
  • ETL Testing
    • ETL Data warehouse Tutorial
    • ETL Concepts Tools and Templates
    • ETL Testing FAQ's
    • ETL Testing Videos
  • Big Data Hadoop
  • Video Tutorials
  • ApachePOI Video Tutorials
  • Downloads
    • E-Books for Professionals
    • Resumes
  • Automation Essencials
    • Cloud Technologies
      • Docker For Testers
      • AWS For Testers
      • Sub Child Category 3
    • Java Collections
    • Selenium Locators
    • Frequently Asked Java Programs
    • Frequently Asked Python Programs
    • Protractor
    • Cypress Web Automation

ETL Tool Selection Process

 ETL Tool Selection Process   

Selecting a tool is an organizational level decision since it will be the base for all future data integration works. Hence huge amount of analysis and time need to be invested before selecting a tool.
Below are few factors to be considered for tool comparisons,

  1. Handling different type of sources
    The tool must have the features to select the source type as a database or flat file. Within the database, it must offer to connect different relational databases. Also within the flat file, it must have the option to select a text file, excel or XML file etc.
  2. Performance
    Performance is one of the key factors which decide the best product in the current market across all industries. The tool must offer good performance in all extraction, transformations and loading components.
  3. Usability
    The user interface and job hierarchy maintenance should be very user-friendly since cannot be afforded a tool which does not have organized properly.  Selecting different components and linking should not take additional efforts. The tool must have job execution monitor to view running status with appropriate details and log files which will make testers job easier. Job flows need to be displayed as pictorial diagrams which will make easy for a user to understand.
  4. Maintenance
    It will be accounted as part of long-term benefit since nowadays the maintenance cost is increasing equal to the development cost.
    The tool should be designed such a way that it gives requires maintenance effort.
  5. Features
    The tool must offer separate components for every transformation which would be easy for building and debugging. Also, it should have provisions to run the java code, run a package, and run shell scripts.
  6. Data quality
    The efficiency of the tool will be decided by the quality of data outcome. All the components must deliver 100% quality.
  7. Support
    The necessary support should be provided at the right time with proper resolution within the defined turnaround time. In case, of urgency on call support need to be given.
  8. Cost
    Affordability of the tool also plays a major role. The tool must offer the cost in affordable rate for the longer period.
  9. Version control
    The tool must give provision to maintain the versioning or can be integrated with version control tool to avoid rework.
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to TwitterShare to Facebook
Newer Post Older Post Home
popup

Popular Posts

  • How To Explain Project In Interview Freshers and Experienced
    “ Describe an important project you’ve worked on ” is one of the most common questions you can expect in an interview. The purpose of a...
  • MANUAL TESTING REAL TIME INTERVIEW QUESTIONS & ANSWERS
    1. How will you receive the project requirements? A. The finalized SRS will be placed in a project repository; we will access it fr...
  • API/Webservices Testing using RestAssured (Part 1)
    Rest Assured : Is an API designed for automating REST services/Rest API's Pre-Requisites Java Free videos: https://www.you...

Facebook Page

Pages

  • Home
  • Resumes
  • Job Websites India/UK/US
  • ISTQB
  • Selenium with Java
  • E-Books for Professionals
  • Manual Testing Tutorials
  • Agile Methodology
  • Manual Testing Projects

Live Traffic

YouTube


Blog Visitors

Copyright © SDET- QA Automation Techie | Powered by Blogger
Design by SDET | Blogger Theme by | Distributed By Gooyaabi Templates