SSIS:
1) how to design a package?
source - file A
Column 1 Column 2
1 name j-date sal
2 name j-date sal
Destination- SQL Server
col1 col2 col3 col4
1 name j-date sal
2
2) Source- Sql Query
Destination- CSV File
i) first time package execute then only header dumped in the output
ii) second time package execute then rows dump in the output destination
why this situation and how can we avoid this?
3) what is prevalidation?
4) how can we avoid this situation mention in question 2 by using prevalidation?
SQL:
1) what are constraint available in Sql server?
2) what is mean by primary key and foreign key?
3) what is difference between cast and convert? explain scenarios where we can use this?
4) what will happen if we move the data from Varchar(3) to char(10)? will be the change?
5) explain different types of joins?
6) what is cross-apply?
7) explain different types of indexes?
8) what is mean by temporary tables, CTE and table variables?
9) difference between temporary tables, CTE and table variables
10) what is temporal tables? explain its purpose? in which case we can use this?
11 ) what are different isolation levels available in SQL server?
12) explain deadlock?
13) in a query there is subquery. how many times subquery will get execute?
14) difference between subquery and correlated subquery
15) what is mean by sp_who()?
16) what is mean by DMV
17) explain query Optimisation?
18) what is mean by statistics and when to update statistics?
19) how can you relate statistics to query plan?
20) what are other concepts than indexes in query plan?

21) explain execution plan in details?