| What is limitation and advantage in using the SQL command as an input source when input in the SQL data source in a data flow task? |
| What is "task" in SSIS? |
| What does SSIS Mean? |
| What are the significant parts of the SSIS package? |
| What is Solution Explorer in SSIS? |
| What is the meaning of data flow in SSIS? |
| What is “task” in SSIS? |
| What is an SSIS package? |
| What are different types of connections that support SSIS? |
| What is the meaning of Precedence Constraint in SSIS? |
| What are the kinds of variables in SSIS? |
| What does a checkpoint in SSIS mean? |
| What are connection managers in SSIS? |
| What does SSIS breakpoint mean? |
| What does logging mode property mean? |
| What is data flow buffer? |
| What do conditional split transactions in SSIS mean? |
| What are the different types of Data viewers in SSIS? |
| What are the possible locations for saving the SSIS package? |
| What is the Event Handlers tab in SSIS? |
| What are three data flow constituents in SSIS? |
| What are different alternatives for dynamic configuration is SSIS? |
| What is Data conversion Transformation? |
| What other tasks can SSIS handle? |
| What do you understand by SSIS control flow system integration? |
| What do you mean by data transformation? |
| What types of containers can be used with SSIS packages? |
| What do you mean by the Deployment process in SSIS? |
| What do you understand by the Manifiest file in SSIS? |
| What is known as the data flow task in SSIS? |
| What is meant by data profiling task? |
| What do you understand by a transaction in the SSIS package? |
| What is the purpose of the config file in SSIS? |
| What is the difference between control flow and data flow? |
| What is a Checkpoint in SSIS? |
| What is the main use of the SSIS package? |
| What is the solution explorer in SSIS? |
| What do you mean by a Task in SSIS? |
| What is Precedence Constraint in SSIS? |
| What do you mean by connection managers in SSIS? |
| What do you understand by SSIS breakpoint? |
| What is event logging in SSIS? |
| What is data flow buffer in SSIS? |
| what is a checkpoint? |
| what is package configuration? |
| What are the types of configurations in SSIS? |
| What are the different types of command-line utilities in SSIS? |
| What is the difference between merge and Union All? |
| What is CDC Splitter? |
| What is OLEDB Command T\R? |
| What is the Dimension table? |
| What is the use CDC control task? |
| What is the event handler? |
| What is Integration Services? |
| What is the difference between union and merge in SSIS? |
| What is Multithreading? |
| What does the master database hold? |
| What are the deployment models in SSIS? |
| What are the important components of SSIS package? |
| What is the control flow? |
| What is a data flow? |
| What is a container? How many types of containers are there in SSIS? |
| What are the different types of containers used in SSIS? |
| What variables in SSIS and what are the types of variables in SSIS? |
| What is SSIS breakpoint? |
| What is logging mode property? |
| What is conditional split transactions in SSIS? |
| What will be your first approach if the package that runs fine in Business Intelligence Development Studio (BIDS) but fails when running from an SQL agent job? |
| What is the role of the Event Handlers tab in SSIS? |
| What is the use of Execute SQL task in SSIS? |
| What is an SSIS Catalog? |
| What is the use of a sequence container? |
| What are important best practices for using SSIS? |
| What is the use of control flow tab in SSIS? |
| What is the Manifest file in SSIS? |
| What is File system deployment? |
| What is the OLE DB Command Transform? |
| What are the types of Lookup Cache Modes present in SSIS? |
| Name 4 important components of the SSIS package? |
| Name the 4 data viewers in SSIS? |
| Name three options for dynamic configuration in SSIS? |
| Name a few blocking transformations? |
| Name the ssis data types for the varchar and nvarchar data types of SQL server? |
| Name different types of connection or files that support SSIS. |
| Name different types of Data viewers in SSIS. |
| Name three data flow components in SSIS. |
| Explain solution Explorer in SSIS. |
| Explain what is a checkpoint in SSIS? |
| Explain connection managers in SSIS. |
| Explain event logging in SSIS. |
| Explain the term data flow buffer? |
| Explain the possible locations to save the SSIS package. |
| Explain the method to perform incremental load? |
| Explain event logging mode property. |
| Explain different options for dynamic configuration is SSIS. |
| Explain Data conversion Transformation. |
| Explain few features of SSIS. |
| Explain two disadvantages of SSIS. |
| Explain project and package control flow in SSIS. |
| Explain use of XML Task. |
| Why check Points are utilized in SSIS? |
| Why check Points used in SSIS? |
| Which are the the three data flow components in SSIS? |
| How many kinds of containers are present in SSIS? |
| How you can inform your workforce about package failure? |
| How logging is done in SSIS? |
| How is the SSIS package deployed on production? |
| How to manage Late Arriving Dimension? |
| How to perform incremental load? |
| How many categories of tasks are there in SSIS? |
| How many types of containers? |
| How to schedule the package? |
| How would you do Logging in SSIS? |
| How does sort transformation work in the ssis, how does it impact the performance? |
| How to change the isolation level in SQL server? |
| How to perform data validation in SSIS? |
| How do we create an excel file and the sheet with defined column and data type in SSIS? |
| How you can notify the staff members about package failure? |
| How would you deploy an SSIS package on production? |
| How to handle Early Arriving Facts or Late Arriving Dimension? |
| How would you stop a package that is running forever? |
| How to create the deployment utility? |
| How does an error occur in SSIS, and what are the most critical errors in SSIS? |
| When is the task of data profiling usually done? |
| When is the activation of the rcsi take place? |
| Difference between Full cache, partial cache and no cache? |
| Difference between DTS and SSIS? |
| Difference between Merge join and lookup? |
| Difference between control flow and data flow? |
| Difference between Merge and Union All? |
| Difference between Execute TSQL Task and Execute SQL Task |
| In which isolation level phantom read does not occur? |
| A package runs without a hitch in BIDS (Business Intelligence Development Studio), but doesn’t run with SQL Agent. What is the most likely reason for this? |
| Can variables be created in SSIS? |
| Can the SSRS RDL in a report server be exported to EXCEL in from a SSIS package .? |
| For what data checkpoint data is not saved? |
| How to achieve parallelism in SSIS? |
| Can the data be viewed as between data tasks? |
| Data checkpoint data is not saved for what? |
| Different types of debugging in SSIS? |
| Different types of transformation in SSIS? |
| List out different types of source systems you have used in your current project |
| Mention the two types of variables that can be created in SSIS? |
| Mention three locations where the SSIS package can be saved? |
| Mention some disadvantages of SSIS? |
| Types of Loggings? |
| Why use SSIS when there is DTS? |
| What is ‘data transformation’? |
| What is a ‘task’? |
16 May 2021
#SSIS
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment