6750 N Andrews Ave #400
Fort Lauderdale, FL 33309
USA
If you have been working in BI for a long time, every time you start a new project the first question you ask is “how clean is the data?” The answer from the business unit is always “real clean!”
Then you start trying to load it and find out it’s not as clean as you were hoping for. You eventually realize it’s never going to be clean, and it’s your job to clean it and load it!
Antonio Fellucca is going to demonstrate some advance options, and they are not the only options, they are another tool in your toolbox option.
In this session, we are going to dive into some advance topics using Script Tasks, Script Components, and Advance features in the Lookup component. We will discuss Visual Studios for Applications (C#) and how to insert rows into Dimension tables when they are missing using the lookup component.
The other components will look at include:
- Derived Column
- Merge Join
- Conditional Split
- Union All
- OLE DB Command
- Source and Destination components
If you’re looking to increase your knowledge using SSIS and then be sure to attend!
Bio: Antonio Fallucca is a high preforming strategic thinking professional with 20 years of Data Warehouse Business Intelligence and Finance experience.
He is Skilled in meeting Performance goals and keeping projects on track. Specializing in Microsoft Business Intelligence, for the last 20 years. Practiced Accountant and Financial Analyst, for fortune 100 company – Financial Reporting and Risk Management and Controls and for the last 20 years Data Warehouse Architect and Developer.
