1. What is logging? What is its purpose?
2. What is package configuration? How will use the package configuration?
3. What is the difference between merge and merge join in SSIS?
4. What is the SSIS Buffer size?What is MIN buffer size?What is MAX Buffer size? what is default buffer size in SSIS?
5. how will you the transform the two souce tables into one destination server without using sorts?
6. diff. bet synchronous and asynchronous in SSIS?
7. What are lookup cash properties?
8. how will u do the performance tuning in SSIS?
9. If a package takes 3 hrs to execute under the job then if it takes 5 hrs, what should we take care of it?
10. If the Parent package has 10 connections and if the child has one connection? How will u handle it?
11. I have 1 shared folder and I want to move it to the other place and I should delete the previous shared folder. How will u do it? what r the components u used for it?
12. Blocking ,non blocking transformation?
13. What is SSIS?What is the use of it comparing to other ETL texhnologies?
14. Diff between union all and merge in SSIS?
15. Diff. between merge and merge join?
16. I Have three sources 1)sql source and the other two r the OLDB Sources , which source will u choose of the three and why in SSIS?
17. What is meant by asynchronous? What r the type of transformations does it contain?
18. What is meant by LOOK UP table? What is the use of it?
19. How did u do transactions in SSIS?
20. Explain the ETL flow in SSIS.
21. what are the transformations used in your project.
22. Difference between conditional split and multicast transformation.
23. how many inputs given to the conditional and multicast transformations.
24. explain SCD.
25. Explain Event handler.
26. Use of Derived column.
27. what datasource used In your project.
28. Diff between Execute SQL task and Oledb command
29. Diff between OLEDB destination and SQL server destination.
30. Configurations used in your project.
31. Blocking transformations.
32. Types of dimensions.
33. How to deploy ssis
àScenario
34. We have 5 csv files,how can send data from csv files to single destinations.
àscenario
35. We have 10 csv files in the folder,file names are having 6 letters lenth,first two letters represents the country code like US,UK.. and next two letters having like numerics like 10 to 99 and next two letters represents quarters like Q1,Q2,Q3,Q4.totally file name like UK44Q2.csv
36. How can validate the file name should be in same order or not,if file name not in the same order then it will be give an error.
37. How can develop this scenario.
àscenario
In ssis package if we load 1000 records in to destination, then how can u send mail to project lead that mail containing information like 1000 records loaded or 2000 records loaded like that depend up on no of records loaded
38. we have 10 csv files ,how can store the file names in to table
39. what is the transaction in ssis.
40. Why do we need datamarts?
41. Kimball and inmon approaches?
42. What are the advantages and disadvantages of those approaches(top down and bottom up)?
43. Pivot and unpivot in sql server?
44. Difference between for each loop and for loop container?
45. Script component
46. How to configure the Error in SSIS?
47. How do you pass the parameter in store procedure? in SSIS
48. How to eliminate invalid characters for transfer data from txt file to sql table?
