Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: fact
484 results found
Loading Type 1 and Type 2 Dimensions made Easy with Task Factory
Ever had to load a Data warehouse? Isn’t it so much fun creating all of those transforms to load a type 2 dimension? Of course it’s not; it is a lot of work. Well now you can load those dimensions very easily using Task factory. Task Factory is a group of
Author:
MikeDavis
Date: 6/8/2011 Section:
Blog
tags :
SSIS
,
Task Factory
,
Tasks
,
Type 1
,
Type 2
Checking a File in Use and File Compression in SSIS with Task Factory
Checking a File in Use and File Compression in SSIS with Task Factory Getting compressed files from customer is a common occurrence in today’s database world. Decompressing and loading those files can be a lot of work, even in SSIS. Task Factory makes thi
Author:
MikeDavis
Date: 6/8/2011 Section:
Blog
tags :
Compression
,
File in Use
,
File Properties
,
Files
,
Task Factory
,
Zip
,
SSIS
Handling Large Many to Many bridge tables
In some scenarios you will need to create a many to many relationship in your cube in SSAS. I have an article that shows you how to do this here . One of the problems that arise from many to many bridge tables are the size of these tables. In this example
Author:
MikeDavis
Date: 5/6/2011 Section:
Blog
tags :
Cube
,
Dimension
,
Factless Fact Table
,
Many to Many
,
SSAS
,
Bridge Table
Process Affected Partions and Creation of Dynamic Partions
Hi ssingam. I really have to spend some time to create a blog with this one. I get a lot of help requests about this one. I would start by naming partitions by their date. Lets say your monthly partitions would be named 201201, 201202, and so on. And your
Author:
marcoadf
Date: 5/24/2012 Section:
Forum
tags :
analysis
,
as
,
create
,
cube
,
dynamic
,
olap
,
partition
,
partitions
,
process
,
services
How to implement Fact Row Versions and incrementally refresh cube
I'm struggling with a warehouse design issue that involves versions of fact rows. I'll try to explain. We have 20,000 devices, each device sends a reading for the previous day. Each reading has a status to tell what type of reading (estimated, Actual, Sus
Author:
PhilMac750
Date: 7/26/2011 Section:
Forum
tags :
Design
,
SSAS
,
versioning
,
warehouse
Foreign Keys in the Datawarehouse
I personally like having PK-FK in the Datawarehouse. Apart from maintaing data integrity, these relationships make building the cubes pretty easy :). I would like to what other people in the forum do with their datawarehouse. Is it a good idea to have Pri
Author:
az.asharma
Date: 6/9/2011 Section:
Forum
tags :
datawarehouse
,
Foreign Keys
,
performance
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
MCTS (70-448) and MCITP (70-452)
In the last September 28th I've passed my 1st microsoft certification. In fact, I've passed 2 microsoft certifications!! Yes, I was able to do both certification exams in the same day. It was my very first experience in certification exams. I've got 1000/
Author:
marcoadf
Date: 12/26/2011 Section:
Blog
tags :
70-448
,
70-452
,
being
,
Certification
,
exams
,
Marco
,
marcoadf
,
MCITP
,
MCTS
,
measured
,
microsoft
,
skill
,
study
,
testking
,
training
Task Factory's Secure FTP Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg
Author:
briankmcdonald
Date: 9/3/2011 Section:
Blog
tags :
Brian K McDonald
,
Secure FTP Task
,
task factory
Add 26 High Powered Tasks to your SSIS Toolbox
As a Business Intelligence Consultant with Pragmatic Works, I have the pleasure of being able to take for a spin any of the sports cars in the garage of Pragmatic Works software. And if you’ve frequented my blog before, you’ve heard about how much I love
Author:
DustinRyan
Date: 6/7/2011 Section:
Blog
tags :
SSIS
,
Task Factory
,
Pragmatic Works
Task Factory - Trim Plus Transform
In previous videos, we've looked at some of the other data cleansing operations Pragmatic Works' Task Factory offers, such as address parsing and case correction. Another common data cleansing task is trimming spaces or characters from the start and end o
Author:
arcanecode
Date: 8/7/2011 Section:
Blog
tags :
Pragmatic Works
,
SQL Server Integration Services
,
SSIS
,
Task Factory
Pull Data from a Sharepoint List with Task Factory's Sharepoint Source!
With the increasing popularity of Sharepoint sites in a lot of shops, wouldn’t it be great to have an easy way to extract data from your Sharepoint lists!? …Well yea. That would be awesome! Fortunately, Pragmatic Works offers such an option f
Author:
kylewalker
Date: 8/17/2011 Section:
Blog
tags :
Sharepoint Source
,
task factory
Task Factory's Address Parse Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg
Author:
briankmcdonald
Date: 9/3/2011 Section:
Blog
tags :
Address Parse Transform
,
Brian K McDonald
,
task factory
Task Factory - TF File Properties
My last video on the Task Factory Compression Task was well received, so I thought I’d build on it with a video on the File Properties Task. It’s a cool little tool that will grab any of the various attributes associated with a file. If you want to see mo
Author:
arcanecode
Date: 7/19/2011 Section:
Blog
tags :
SQL Server Integraion Services
,
SSIS
,
Task Factory
,
Pragmatic Works
Task Factory Null Transform
Nulls. Seems like they are the universal headache among all data based projects. Trying to clean up nulls in SSIS is certainly doable, but not without some work with expressions. An equal headache to null values are blank values. In most cases, you’ll eit
Author:
arcanecode
Date: 7/9/2011 Section:
Blog
tags :
Null Transform
,
SQL Server Integration Services
,
SSIS
,
Task Factory
SSIS Advanced Execute Package Task with Task Factory
In the last few months, I've been giving a preview on some of the new advanced SSIS tasks and transforms being released in the coming version of Task Factory. Well Task Factory 3.0 has finally been released last month, and its packed with a ton of really
Author:
DustinRyan
Date: 8/22/2012 Section:
Blog
tags :
Execute package task
,
ssis
,
task factory
Many to Many relationship ("bridge table") with healthcare data
I'm using SQL Server 2005 to develop a healthcare claims data warehouse while attempting to employ Kimball's dimensional modeling techniques. For anyone who has the book "The Data Warehouse Toolkit (2nd ed.)", check out page 263 (Figure 13.3). Unfortunate
Author:
peterzeke
Date: 4/8/2010 Section:
Forum
tags :
bridge table
,
factless table
,
many-to-many relationships
Sneak Peek: Super Advanced Derived Column Transform In Next Release of Task Factory
Don't ask how I was able to acquire these screenshots or what favors I may or may not have performed in order to snag these pics of the next release of Task Factory. I'm not proud of what I've become. But the fact of the matter is that Task Factory 3.0 is
Author:
DustinRyan
Date: 5/31/2012 Section:
Blog
tags :
derived column Transform
,
SSIS expression
Add missing dimension members during
fact
load
This is a variation of a pattern I saw in SQL Server Integration Services Problem Design Solution by Erik Veerman, Jessica Moss, Brian Knight, and Jay Hackney. I would highly recommend this book. I found at least 4 chapters in the book that were each wort
Author:
Daniel
Date: 4/20/2012 Section:
Blog
tags :
Inferred member
,
missing dimension lookup
Related Facts & Cross Measure analysis
Hi, I'm hoping this isn't a re-post - i searched and couldn't find an answer so i thought I'd post the question. Simplified Scenario: 3 related facts Sales Fact {SaleId, CustomerId, StoreId, ProductId, SaleYear, Amount} Customer Status Fact {CustomerId, S
Author:
feemurk
Date: 7/8/2010 Section:
Forum
tags :
Dimensional modeling
,
Many-to-Many Relationships
,
ssas
SalesForce Source from Task Factory
Below I will show you how to use the SalesForce Source within your dataflow. As you will see below this is very easy to configure thanks to Task Factory. First things first you need to drag over the SalesForce Source into the dataflow. After that you will
Author:
ChrisAlbrektson
Date: 6/30/2011 Section:
Blog
tags :
Pragmatic Works
,
Sales Force
,
Sales Force Source
,
SalesForce
,
Task Factory
Task Factory: Email Source and Delete Email Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg
Author:
briankmcdonald
Date: 9/3/2011 Section:
Blog
tags :
Brian K McDonald
,
Delete Email Task
,
Email Source
,
task factory
Task Factory Advanced E-mail and SMS Task
A few weeks back I created a quirky little video comparing the differences between the standard Send Email Task and Task Factory's Advanced E-mail and SMS Task . Thought you guys might find it interesting, so let me know what you think!
Author:
Tyler
Date: 7/22/2011 Section:
Blog
tags :
E-mail
,
Factory
,
SMS
,
SSIS
,
Task
How to check whether source file exists or not in a dialy load package
Saraswathi, This is a little more "advanced" because installing new SSIS components can be tricky if you're new to it. That being said, another good option to consider is "Task Factory" from Pragmatic Works. http://www.pragmaticworks.com/Products/Business
Author:
KeithHyer
Date: 10/13/2010 Section:
Forum
tags :
exist
,
file properties task
,
file
,
pragmatic works
,
task factory
Page 1 of 20 (484 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]