T-Systems ICT India Senior Consultant Interview Questions, Process, and Tips

TestNG and Maven provide options to run failed/specific test cases and suites.

• To run failed test cases in TestNG, use the 'rerun-failed' option in the testng.xml file.

• To run specific set of test cases, use the 'include' or 'exclude' tags in the testng.xml file.

• To run specific suite in Maven, use the '-Dtest' option followed by the name of the suite.

• To run failed test cases in Maven, use the '-rf' option followed by the

Physical join refers to the actual combination of data from two or more tables, while logical join refers to the method used to combine the data.

• Physical join involves the actual merging of tables, while logical join involves the use of operators such as AND, OR, and NOT to combine data.

• Physical join can be performed using different techniques such as nested loop join, hash join, and merge join, while logical join can ...read more

Indexes are used to improve database performance. There are different types of indexes.

• Clustered index

• Non-clustered index

• Unique index

• Covering index

• Bitmap index

Nested join and merge join are two types of join operations in database management systems.

• Nested join is a join operation where one join condition is nested inside another join condition.

• Merge join is a join operation where two sorted datasets are merged together based on a common attribute.

• Nested join is slower than merge join due to the nested loop required to perform the join.

• Merge join is faster than nested join a...read more

Blocking transformations halt the pipeline until all data is processed, while non-blocking transformations allow data to flow through immediately.

• Blocking transformations wait for all input data before processing

• Non-blocking transformations allow data to pass through immediately

• Blocking transformations include Aggregator, Joiner, and Sorter

• Non-blocking transformations include Expression, Filter, and Router