Client -- Pennymac
Topic starter 11/02/2022 10:16 pm
- 1. What is the Manifest file in SSIS?
- 2. What is the data flow task in SSIS and what transform you use?
- 3. Difference between Merge and Union All?
- 4. What is a transaction in the SSIS package and how to implement it?
- 5. What is Precedence Constraints?
- 6. How do you get an SSIS package to only insert new records when copying data between servers?
- 7. What is merge join ?
- 8. Difference between delete and drop?
- 9. What is CTE?
- 10. What is the size of data warehouse ?
- 11. what is the type of data warehouse you worked?