Client -- Pennymac

Last Post

RSS

Jyoti Negi

(@jyoti-negi)

New Member

Joined: 5 months ago

Posts: 3

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?