UST ETL Developer Interview Questions and Answers

Q1. Some in depth questions about python and java
Add your answer

Asked some problem solving questions they will allow to choose the language it's good

Q1. What is inital load in ETL
Ans. 
Initial load in ETL refers to the process of loading data from source systems into the data warehouse for the first time.
• Initial load is typically a one-time process to populate the data warehouse with historical data.

• It involves extracting data from source systems, transforming it as needed, and loading it into the data warehouse.

• Initial load is often done using bulk loading techniques to efficiently transfer large vo...read more
Answered by AI
Add your answer
Q2. What is difference between cluster and non cluster index
Ans. 
Cluster index physically orders the data on disk, while non-cluster index does not.
• Cluster index physically orders the data on disk based on the indexed column

• Non-cluster index does not physically order the data on disk

• Cluster index can only have one per table, while non-cluster index can have multiple

• Cluster index is faster for retrieval but slower for inserts and updates
Answered by AI
Add your answer