You manage a retail database that includes Customers, Orders, and OrderDetails tables. Question: Find the top 5 customers who have spent the most on orders in the last year. Details Columns: Customers: CustomerID, CustomerName Orders: OrderID, CustomerID, OrderDate OrderDetails: OrderID, ProductID, Quantity, Price
SSIS, SQL
Technical difficulties in achieving the business requirement
Datwarehouse concepts, SSIS and SSAS scenarios
11) What is subquery -> 12) What is circular reference /deadlock 13) What is serialization and deserialization 14) What is public and static 15) What types of variable types in SSIS string bollen int 32 int64 17) Normalization and denormalization 19) What are DB constraints 20) What sources have you used in DFT
1) What is control flow 2) What is data flow 3) Explain multicast 4) What is checkpoint 5) What is transactions 6) How to get count in the table 7) How to debug the script task -> mentioned breakpoints 8) Do you know deployment 9) How to backup the ssis package 10) What is manifest file -> created at the tme of deployement
query to get last of month of date 25052019
basics of ssrs reports, drill down dil through
Viewing 51 - 60 interview questions