Let’s face it, many of us have performance issues with SSIS. Would you like to learn how to load your data up to 3000% faster? Who wouldn’t, right? Now imagine this with the benefit of creating cleaner data. Sound too good to be true?
Category: Task Factory34 Results
We're kicking off the month exhibiting at PASS Summit 2017 in Seattle, WA and hosting our 6th annual SQL Karaoke event, often considered to be the highlight of PASS. You can follow us on our social platforms like Twitter and Facebook to stay updated on daily happenings at this event.
Check out what else we have coming up this month in our training, software and consulting departments!
Even though many people think data warehouses ETLs (extract, transform and load) should contain insert data flows only, the vast majority of people I work with also have to deal with updates. Many also have to handle marking data warehouse rows as IsDeleted = "Y" in their ODS and EDW data repositories.
If you are working with a dimension table with less than 500K rows (an estimate), a traditional lookup task might work just fine. The data flow would look like this:
As a consumer or potential customer, I’m often required to fill in my address details when completing a web form on various sites. The idea is this, I go from a potential lead into your database, which can then be marketed to in the form of email outreaches or physical mail campaigns where brochures or coupons are sent to my physical address.
You’ll probably agree that one of the most valuable assets to your company is your customer database. But do you know that bad data in your client addresses can cost you thousands of dollars each year? 4.7% of ecommerce address data is undeliverable as entered by customers and 35% is undeliverable is due to undeliverable addresses. The average company loses $254 per 1,000 pieces of mail returned.
If you use Survey Monkey, are you looking for an easier way to get and utilize that information for your business? Survey Monkey is a great tool for getting useful information and keeping in touch with clients. At Pragmatic Works, we use it for things like post-event follow up, emails after demos for feedback and at the completion of consulting engagements.
Pragmatic Works has done a series of blogs and videos discussing how our Task Factory REST Source can help you easily get the data you need from web services, such as Salesforce, GoToWebinar and Google Analytics. Here, we want to show how REST Source helped our Training Director, Devin Knight, with Litmos.
Need help with this topic? Ask the author below.