TCS iON Senior Modeller Interview Questions and Answers

Q1. About your experience
Add your answer
Q2. OLTP and OLAP difference
Ans. 
OLTP is for transaction processing, OLAP is for analytics and reporting.
• OLTP stands for Online Transaction Processing, used for real-time transaction processing.

• OLAP stands for Online Analytical Processing, used for complex queries and data analysis.

• OLTP databases are normalized, while OLAP databases are denormalized for faster query performance.

• OLTP systems are optimized for write operations, while OLAP systems are op...read more
Answered by AI
Add your answer

Q1. What is top down approach
Ans. 
Top down approach is a problem solving or design strategy that starts with the larger overview and breaks it down into smaller components.
• Start with a broad overview of the problem or design

• Break it down into smaller components or sub-problems

• Address each component individually before integrating them back together

• Commonly used in software development, project management, and system design
Answered by AI
Add your answer
Q2. Star vs snowflake schema
Ans. 
Star schema is a denormalized schema with a single central fact table surrounded by dimension tables. Snowflake schema is a normalized schema with multiple interconnected dimension tables.
• Star schema is easier to understand and query due to denormalization.

• Snowflake schema saves storage space by normalizing data.

• Star schema is better for data warehousing and reporting, while snowflake schema is better for OLAP systems.

• ...read more
Answered by AI
Add your answer

Q1. SQL queries were given
Add your answer
Q2. Design a data model
Ans. 
Design a data model for a customer relationship management system
• Identify entities such as customers, products, orders, and sales representatives

• Establish relationships between entities (e.g. a customer can place multiple orders)

• Define attributes for each entity (e.g. customer name, product price)

• Consider normalization to reduce redundancy and improve data integrity
Answered by AI
Add your answer

Q1. Basics of manufacturing process
Add your answer

Q1. They will give tool test on structural model
Add your answer

Q1. What are the GD and t symbols
Ans. 
GD&T symbols are used in engineering drawings to specify the geometric characteristics of a part.
• GD&T stands for Geometric Dimensioning and Tolerancing

• Symbols include position, concentricity, flatness, parallelism, perpendicularity, and more

• Used to communicate design requirements and tolerances for manufacturing processes
Answered by AI
Add your answer

Q1. About last working experience
Add your answer
Q2. Overall on resume
Add your answer

Cad test,3d modeling in creo

Q1. Basic related to drawing and past experience
Add your answer