I am New to SSIS Could you give me some details
Hello every body
I am New to SSIS. Please send me answers detail description with some examples ie great help to me.
1. SSIS(sql server Integration services)
2. SSIS Architecture
3. Different types of transaction we can do in SSIS
4. How will you do Error Handling in SSIS
5. How do you Performance tuning
6. Difference between lookup and fuzzy lookup transformations
7. What are different types of data types in SSIS
8. What is Data Soruce view
9. What is Databinding
10. How to migrates DTS packages, what kind of errors while migrating.
11. What is Difference between Data mart and Data ware house
12. What is SCD1, SCd2,SCD3
13. What is Lineage ID in SSIS
14. CLR(common Languge Run time)
15. How to do version control
16. How to do logging in SSIS
17. What is PIVOT and UNPIVOT in SSIS
18. How to deploy the packages in SSIS
19. What is advantages strong the database and strong the file
20. What is XML role in SSIS
21. Walk through common transformation
22. What is maintain task
23. What is transferring job in SSIS
24. What is Precedence constrainst in SSIS[/b]
|
