Nitor Infotech, an Ascendion company Interview Questions, Process, and Tips

Fill in the blanks like questions

Q1. A custom 2 pointers
Ans. 
Custom 2 pointers question for Junior Engineer interview.
• Explain the concept of 2 pointers technique in array manipulation.

• Discuss how 2 pointers can be used to solve problems like finding a pair with a given sum in an array.

• Provide examples of using 2 pointers to solve problems efficiently.
Answered by AI
Add your answer
Q2. Basic c# crud operation
Add your answer

Q1. Api call in Angular
Ans. 
Api call in Angular involves making HTTP requests to fetch data from a server.
• Use HttpClient module to make API calls

• Subscribe to the Observable returned by the HTTP request

• Handle the response data or errors in the subscription callback function
Answered by AI
Add your answer

Q1. Related to python, llm
Add your answer

Q1. Neural networks
Add your answer

Q1. Basic technical questions
Add your answer

Q1. Technical questions Javascript basics, Node js
Add your answer

Q1. Salary discussion
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. How to load data incrementally
Ans. 
Loading data incrementally involves updating only new or changed data instead of reloading entire dataset.
• Identify the key field that determines new or updated records

• Use timestamp or versioning to track changes

• Implement a process to extract, transform, and load only new or updated data

• Consider using tools like Change Data Capture (CDC) or Incremental Load in ETL processes
Answered by AI
Add your answer
Q2. What are SCD types
Ans. 
SCD types refer to slowly changing dimensions in data warehousing, categorized into Type 1, Type 2, and Type 3.
• Type 1: Overwrite existing data with new data, losing historical information.

• Type 2: Create a new record for each change, preserving historical data with a new surrogate key.

• Type 3: Maintain both old and new values in separate columns within the same record.
Answered by AI
Add your answer