BAeHAL Software Selenium Interview Questions
Can someone help me out with the scenario – I have an excel template with dynamic rows (can be up to 1 Lac – 2 Lac) and 31 columns, I am inserting this template with the help of an application.
After submitting the template, all the data will be loaded into the database. How can I validate that the data in the template and database is posted correctly?
Ans: you can follow the below steps to solve your problem.
- Use Apache POI API to read data from excel, basically what you should do is iterate over the columns and rows and save that data into a Hashmap, your columns would be the keys of this hashmap and values would be the values of the columns. This would be your expected result.
- Now connect to your DB using the respective DB connection API (in case your using Oracle and Java use Java JDBC API), write your custom query which will fetch you the required Data and execute as part of your statement object, you will get a result set containing all the values, iterate over the resultset and store the values as part of another Hashmap same like the above step, but name it as actual result.
- Compare the values of each key of expected and actual result hashmaps, Use apache commons library to compare these hashmaps since it is null safe, just google how to use apache commons library you will get to know,
Please note:- The above-said process eats up a lot of your memory space if I were you I wouldn’t have validated all the data because it’s exhaustive testing, just would have validated for n, n+1, and n+2 Scenarios.
About BAeHAL Software
Established in 1993 in Bangalore BAeHAL provides IT solutions and services to Aerospace, Defence, Transport and Engineering Industries. BAeHAL is built on the strength of its parentage to deliver world-class IT solutions for clients across the world. Flexible, high quality, cost-effective IT solutions are offered to customers for both onsite and offshore services.
BAE Systems is a global company engaged in the development, delivery, and support of advanced defence, security and aerospace systems in the air, on land and at sea. BAE Systems has major operations across five continents, with customers and partners in more than 100 countries. BAE Systems has strong positions in each of our six home markets – Australia, Saudi Arabia, South Africa, Sweden, UK, US – and have organized the business to reflect this.
Hindustan Aeronautics Limited (HAL) is one of the largest aircraft manufacturing companies in Asia.HAL has 19 Production Units and 9 Research and Design Centres in 7 locations in India. The Company has an impressive product track record – 12 types of aircraft manufactured with in-house R & D and 14 types produced under license. HAL has manufactured over 3550 aircraft, 3600 engines and overhauled over 8150 aircraft and 27300 engines.
Check Also: Capco Technologies Interview Questions
“To be a world-class company in providing high technology and quality software solutions and services for global business needs in Aerospace, Defence and other chosen areas”.
“To achieve these objectives by providing solutions and services meeting customer needs, value for employees and satisfaction to shareholders, vendors and for the society at large”.
Needs to demonstrate its ability to consistently provide a product that meets customer and applicable regulatory requirements, and aims to enhance customer satisfaction through the effective application of the system, including processes for continual improvement of the system and the assurance of conformity to customer and applicable regulatory requirements.
BAeHAL has been successfully assessed at SEI CMMI Level 3 by KPMG India. The assessment and the scope of the assessment (using SCAMPISM, Class A methodology) included all software development, testing, and maintenance services. The focus of the assessment included 18 Key Process Areas of maturity level 3 CMMI (Dev V1.2).