Exam (elaborations)
SSIS EXAM QUESTIONS AND VERIFIED ANSWERS
- Course
- Institution
SSIS EXAM QUESTIONS AND VERIFIED ANSWERS...
[Show more]
Content preview
SSIS EXAM QUESTIONS ANDVERIFIED ANSWERS
SSIS - What is a checkpoint - ANSWER *DEFINITION*: A checkpoint
in SSIS is a feature that can be implemented to have a restarting point if
a package fails. The package, upon failure, will restart at that checkpoint
when run again.
*EXAMPLE*: I have used checkpoints in larger and more complex
packages to avoid having to restart from the beginning when and if the
package fails. I've recently used it in my HSI project where there are
steps/tasks in each package to perform extraction using multiple
dataflow tasks.
**View
- https://youtu.be/6D3n0C1c1h4
- https://www.red-gate.com/simple-talk/sql/sql-tools/implementing-
checkpoints-in-an-ssis-package/
*MORE*: The system saves an xml file that stores data about the
package (the variables/results) locally so when it re-runs, it picks up all
that information and resums from the checkpoint location.
SSIS - What are the various types of sources you have worked with? -
ANSWER *DEFINITION*: I have most commonly used flat file, excel,
OLE DB, and xml data sources.
*EXAMPLE*:
In one of my projects, I used a For Each Loop to load the csv files stored
in a folder, which had the financials of the FTTC projects to ultimately
store it in a staging table for further scrubbing.
In that same package, I used OLE DB source to extract the Project
Management information about the associated project numbers.
SQL - What is a Data Dictionary - ANSWER *DEFINITION*: In SQL
Server the data dictionary is a set of database tables used to store
, information about a database's definition. It's basically tables that house
data on the database tables (attributes about the tables - column names,
constraints, data types, ...etc). One is also able to create data dictionary
to give more description about the columns in a table such as what its
purpose is.
*EXAMPLE*: there are system views that is available for querying.
Although one can directly query the system tables, these views are
recommended as they already have the necessary joins to display the
'names' of the objects, columns, attributes.
SSIS - How do you load multiple files in EXCEL - ANSWER
*DEFINITION*: One can load multiple Excel files by using a For Each
Loop.
*1. Create variables* to store the file name and file path.
*2. Add a Fore Each Loop* in the Control Flow
<a. configured for the enumerator to be for each enumerator
<b. map variables
*3. Add data flow task* in the for each loop (first create the data flow as
desired & test with 1 file)
<a. use excel (dynamic) connection
<b. use excel source
*4. Set the properties* of the control flow tasks and container to *'delay
validation = true'*
*EXAMPLE*:
I have used the For Each Loop to load several excel spreadsheets from
a folder by using the steps mentioned earlier.
To make it more dynamic, I created user defined variables to store the
filename & filepath. Then configured the data connection manager & For
Each look to use those variables. This also made the package easier to
maintain IF the path & file names change.
SSIS - How do you load XML files? - ANSWER *DEFINITION*: To load
an XML file, one would use an XML source by first adding a data flow
task in the control flow. In the data flow window,
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79079 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now