SSIS
96.?
1. Check Point File Extension? Ans : .XML
2. Do you have participated in jobs creation . Then how to schedule the job , then how to send the mail to the client?
3. What type of sources getting from your client?
4. How to configure the packages and what type of configuration files used in your packages to which purpose you use it?
5. In SSIS diff bw Join and MergeJoin?
6. How to eliminate the Duplicate rows in SSIS packages?
7. Do you have participated in SCDs ? which type of SCD used in your project?
8. What are the SSIS Components?
9. What is use of configuration file in SSIS?
10. Wt are the joins used in SSIS packages?
11. Architecture changes in 2012?
12. Transactions and Event Handling?
13. Logging and how to create logging?
14. How you create Caches in SSIS Package?
15. Wt is script task and wt language is used in your script task?
16. Diff bw control flow and dataflow?
17. How you used check points in your SSIS Package and wt are the advantages of Check Points?
18. Diff bw Union and Join?
19. Wt are the activities in SSIS Package?
20. How to delete values from tables using SSIS packages? When table is unknown then how to delete a table using SSIS?
21. To load a 15000 records from Excel sheet to DataBase using Direct Loading?
Ans: to use Bulk Insert
For day to day insert to use INCREMENTAL Loading
22. How to configure Excel file?
23. Wt is Configuration file ? How we use in SSIS Package?
24. How to connect Package1 to Package2 using Variables?
25. How to Debugging a package and tell me different types ?
26. How to use Configuration files in SSIS?
27. HOW TO CONNECT OTHER DATABASE
28. SEMI-BLOKING T/F
29. DIFFERENCE B/W OLEDB AND SQLSERVERDESTINATIO
30. SYNCHRONOUS TRANSFORMATION
31. DIFFERENCE B/W SQLSERVER 2005 &2008
32. D/F B/W DTS AND SSIS
33. Difference bw Check Points & Break Points?
34. How many ways we can deploy the SSIS Packages?
35. How to create a package without using DFT Task?
36. Diff bw UnionALL & MergeJoin?
37. Diff bw LookUp & Fuzzy LookUp?
38. Wt is ERROR Handling?
39. What are the challenging situations you are faced in SSIS?
40. IN MY SOURCE .TXT,.CSV,EXCEL FILES ARE THERE HOW CAN YOU LOADE IN TO ONE DATABASE
41. HOW TO MOVE ONE DATABASE TO ANOTHER DATABASE WITH ALL BASE OBJECT
42.
43. HOW DO YOU RUN 3 TASK PARALLE
44. Wt type of info provided in Progress Tab?
45. Briefly explain about SCDs in SSIS?
46. Wt is DT_STR , DT_WSTR?
47. Wt type of files getting from client & getting to load Data Base?
48. How to configure a Flat File properties in SSIS Package?
49. Wt type of Testing you are using in your project?
50. Can you move set of files to destination , if possible which task you use?
51. Can we use Execute SQL Task params in another task/not?
52. SCD – Business Key, Changing attribute Key
53. Derieved Column?
54. Can we put 3-pages PDF data into a Single page?
55. Do you created any DTS Packages?
56. Tell me Control Flow Tasks?
57. Wt is Aggregation?
58. How to configure XML, Excel Files in SSIS?
59. Types of Row_By_Row transaction tasks?
60. Types of Variables?
61. Transaction Types?
62. OLEDB: Object Linking Embedded DataBase
63. How to Use For Loop & For Each Loop containers in Real Time?
64. Types of Control Flow Tasks?
65. Are you used parameters in any SSIS package?
parameters are the replacement for configurations that are in the current version of SSIS (i.e. SSIS2008).
There are two types of parameters:
• Project parameters
• Package parameters
We can see these in Expression Builder.
66. What is a conditional split?
67. precidence constraint?
68. SCD Type2,Manual SCD?
69. Difference between FORLOOP and FOREACHLOOP?
70. Wt are the Tasks you used in your Project?
71. Wt is Transformation & Why we use Transformation?
To perform intermediate Operations.
72. Where you write SQL Queries in your SSIS Package?
73. List of Some Transformations?
74. OLEDB Source,OLEDB Destination, Connection all are correct but data not moved to destination . Why?
Wt is the problem?
75. Containers in Control Flow?
76. If any Bugs are happened how you Debug it / wt can we do?
77. Wt are the Errors we find in Real Time?
78. How can we get the data from the Clients?
79. Wt is Row Data ? how can you get that?
80. How SCD is helped in your project?
81. Scenario:
Update 1-table in one server & insert values into one table in another server. Which task we use in SSIS.
Ans: Except “Execute SQL Task” any other answer.
82. how use execute sql task in ssis package
83. how to call child package from parent package using a variable
You can pass information from a parent package to a child via a Parent Package Variable Configuration.
On both packages we will create a string variable named "strVar"
parent package variable value is “parent”
and same as “child” in Child package.
Now
In parent pkg drag & Drop the EXECUTE SQL Task and point it to the location of Child Package
Now
In Child pkg , RC on ControlFlow Task & Select Pkg Configurations click on ADD then select config menu as “Parent pack Variable” and in the Parent Variable field give “StrVar”(Parent VarName) Next
now click on “Object” pane (leftside) now select the VarName of “StrVar” (+) and then select “Value” tab(means we copying the parent variable) Finish.
Now
We can verify value by Script task. By executing we we will get Parent value, and if you want to get child value alone you need to run child pack alone.
84. when u create log file using sql server log file in which data base table it store
85. what is use of SSIS configurations
86. what are the isolation levels in SSIS, How it is usefull for package executions
87. what is bridge table
88. How to use configuration files in ssis
89. How to provide a security for packages
90. how to execute packages with out using the the dataflow task
91. HOW TO CONFIGURE THE EXCEL FILE
10)
ID
1
2
3
4
5
6
7
8
9
10
I WANT BOTTOM 2 NUMBERS WITH OUT USING WHERECLAUSE
92. WHAT IS MAGIC TABLES
93.
ID
1
1
1
1
2
2
2
3
3
3
4
4
4
4
4
4
4
I WANT OUTPUT LIKE THIS
1-4
2-3
3-3
4-7
94. IN THE ABOVE TABLE I WANT OUTPUT
3-3
4-7
95.
96.?
1. Check Point File Extension? Ans : .XML
2. Do you have participated in jobs creation . Then how to schedule the job , then how to send the mail to the client?
3. What type of sources getting from your client?
4. How to configure the packages and what type of configuration files used in your packages to which purpose you use it?
5. In SSIS diff bw Join and MergeJoin?
6. How to eliminate the Duplicate rows in SSIS packages?
7. Do you have participated in SCDs ? which type of SCD used in your project?
8. What are the SSIS Components?
9. What is use of configuration file in SSIS?
10. Wt are the joins used in SSIS packages?
11. Architecture changes in 2012?
12. Transactions and Event Handling?
13. Logging and how to create logging?
14. How you create Caches in SSIS Package?
15. Wt is script task and wt language is used in your script task?
16. Diff bw control flow and dataflow?
17. How you used check points in your SSIS Package and wt are the advantages of Check Points?
18. Diff bw Union and Join?
19. Wt are the activities in SSIS Package?
20. How to delete values from tables using SSIS packages? When table is unknown then how to delete a table using SSIS?
21. To load a 15000 records from Excel sheet to DataBase using Direct Loading?
Ans: to use Bulk Insert
For day to day insert to use INCREMENTAL Loading
22. How to configure Excel file?
23. Wt is Configuration file ? How we use in SSIS Package?
24. How to connect Package1 to Package2 using Variables?
25. How to Debugging a package and tell me different types ?
26. How to use Configuration files in SSIS?
27. HOW TO CONNECT OTHER DATABASE
28. SEMI-BLOKING T/F
29. DIFFERENCE B/W OLEDB AND SQLSERVERDESTINATIO
30. SYNCHRONOUS TRANSFORMATION
31. DIFFERENCE B/W SQLSERVER 2005 &2008
32. D/F B/W DTS AND SSIS
33. Difference bw Check Points & Break Points?
34. How many ways we can deploy the SSIS Packages?
35. How to create a package without using DFT Task?
36. Diff bw UnionALL & MergeJoin?
37. Diff bw LookUp & Fuzzy LookUp?
38. Wt is ERROR Handling?
39. What are the challenging situations you are faced in SSIS?
40. IN MY SOURCE .TXT,.CSV,EXCEL FILES ARE THERE HOW CAN YOU LOADE IN TO ONE DATABASE
41. HOW TO MOVE ONE DATABASE TO ANOTHER DATABASE WITH ALL BASE OBJECT
42.
43. HOW DO YOU RUN 3 TASK PARALLE
44. Wt type of info provided in Progress Tab?
45. Briefly explain about SCDs in SSIS?
46. Wt is DT_STR , DT_WSTR?
47. Wt type of files getting from client & getting to load Data Base?
48. How to configure a Flat File properties in SSIS Package?
49. Wt type of Testing you are using in your project?
50. Can you move set of files to destination , if possible which task you use?
51. Can we use Execute SQL Task params in another task/not?
52. SCD – Business Key, Changing attribute Key
53. Derieved Column?
54. Can we put 3-pages PDF data into a Single page?
55. Do you created any DTS Packages?
56. Tell me Control Flow Tasks?
57. Wt is Aggregation?
58. How to configure XML, Excel Files in SSIS?
59. Types of Row_By_Row transaction tasks?
60. Types of Variables?
61. Transaction Types?
62. OLEDB: Object Linking Embedded DataBase
63. How to Use For Loop & For Each Loop containers in Real Time?
64. Types of Control Flow Tasks?
65. Are you used parameters in any SSIS package?
parameters are the replacement for configurations that are in the current version of SSIS (i.e. SSIS2008).
There are two types of parameters:
• Project parameters
• Package parameters
We can see these in Expression Builder.
66. What is a conditional split?
67. precidence constraint?
68. SCD Type2,Manual SCD?
69. Difference between FORLOOP and FOREACHLOOP?
70. Wt are the Tasks you used in your Project?
71. Wt is Transformation & Why we use Transformation?
To perform intermediate Operations.
72. Where you write SQL Queries in your SSIS Package?
73. List of Some Transformations?
74. OLEDB Source,OLEDB Destination, Connection all are correct but data not moved to destination . Why?
Wt is the problem?
75. Containers in Control Flow?
76. If any Bugs are happened how you Debug it / wt can we do?
77. Wt are the Errors we find in Real Time?
78. How can we get the data from the Clients?
79. Wt is Row Data ? how can you get that?
80. How SCD is helped in your project?
81. Scenario:
Update 1-table in one server & insert values into one table in another server. Which task we use in SSIS.
Ans: Except “Execute SQL Task” any other answer.
82. how use execute sql task in ssis package
83. how to call child package from parent package using a variable
You can pass information from a parent package to a child via a Parent Package Variable Configuration.
On both packages we will create a string variable named "strVar"
parent package variable value is “parent”
and same as “child” in Child package.
Now
In parent pkg drag & Drop the EXECUTE SQL Task and point it to the location of Child Package
Now
In Child pkg , RC on ControlFlow Task & Select Pkg Configurations click on ADD then select config menu as “Parent pack Variable” and in the Parent Variable field give “StrVar”(Parent VarName) Next
now click on “Object” pane (leftside) now select the VarName of “StrVar” (+) and then select “Value” tab(means we copying the parent variable) Finish.
Now
We can verify value by Script task. By executing we we will get Parent value, and if you want to get child value alone you need to run child pack alone.
84. when u create log file using sql server log file in which data base table it store
85. what is use of SSIS configurations
86. what are the isolation levels in SSIS, How it is usefull for package executions
87. what is bridge table
88. How to use configuration files in ssis
89. How to provide a security for packages
90. how to execute packages with out using the the dataflow task
91. HOW TO CONFIGURE THE EXCEL FILE
10)
ID
1
2
3
4
5
6
7
8
9
10
I WANT BOTTOM 2 NUMBERS WITH OUT USING WHERECLAUSE
92. WHAT IS MAGIC TABLES
93.
ID
1
1
1
1
2
2
2
3
3
3
4
4
4
4
4
4
4
I WANT OUTPUT LIKE THIS
1-4
2-3
3-3
4-7
94. IN THE ABOVE TABLE I WANT OUTPUT
3-3
4-7
95.
93:
ReplyDeleteans:create table t27(id int)
insert into t27 values(1),(1),(1),(1),(2),(2),(2),(3),(3),(3),(4),(4),(4),(4),(4),(4),(4)
select id,COUNT(*) as id from t27 group by id having COUNT(*)>1