|
|
-
|
|
When I got my old job back, naturally I’ve noticed many of the existing ETL processes have been modified with new business rules.
However, many of the business rules were added in a way that existing rules were barely touched. This has caused issues in several ways:
Existing rules might be......
|
|
-
|
|
There are so many warnings from experienced SQL developers about not to write SELECT * in your query.
I recently got an email from our employee incentive payout team about a SQL view that behaved strangely. They’ve noticed that a date time field is showing employee login ids.
The SQL view is......
|
|
-
|
|
Again if you ever need to work on DB2, here is a shorthand syntax to create a physical table based on the SQL query you’ve already built.
create table myschema.tblMyTableName as (
myQuery
) definition only in myTableSpace
......
|
|
-
|
|
One of the complains I got from many people is that it’s hard to deploy SSIS packages. It is, in some sense, comparing to compiling a stored procedure directly on a SQL server. Instead, developers need to design and develop their packages in a file system, then deploy the packages to the serve......
|
|
-
|
|
Put this in your toolkit if you need to query against a DB2 source.
SELECT * FROM myDB2Schema.myDB2Table FETCH FIRST 100 ROWS ONLY......
|
|
-
|
|
Very often, we know the table name, but do not know which procedure populates the table (assuming that it’s a stored procedure that does that, not a SSIS package).
Use this simple query against the INFORMATION_SCHMEA.ROUTINES:
select specific_catalog
, specific_schema
, ......
|
|
-
|
|
The most common task in an ETL process is to determine what to update, what to delete and what to insert using criteria that are specific to what you are doing.
One of the routine tasks in the asset management master database ETL project is to use a composite key of host name + serial number to det......
|
|
-
|
|
If you are a SQL developer, not much an analyst, you would probably not pay attention to why users need to standardize certain data elements. But that is not my point. My point is actually opposite. As SQL developers, we need to pay close attentions to what our users are saying.
Here is an example.......
|
|
-
|
|
ROW_NUMBER() function has been available since SQL Server 2005. There are many good articles out there about this function. There are many bad ones out there too. (So be careful about what you reading. Always create test cases for your data to make sure you get the results you expect.)
ROW_NUMBER()......
|
|
-
|
|
I recently started to use the SQL 2008 Reporting Services in BIDS 2008. There are many nice enhancements in the new version. The first enhancement I noticed is the new Report Data window. Report Data can be viewed by going to View menu then select View Data option at the bottom of the option list.
......
|
|