Ask the Experts
Ask the Experts
-
ETL tools and EDR tools: What's the difference?
Learn the difference between extract, transform and load (ETL) tools and enterprise data replication (EDR) tools -- from data integration expert Jill Dyché. Continue Reading
-
Career growth of a software developer
Career growth depends on how well you do your job, who you work for and the cost of replacing and outsourcing what you do. Continue Reading
-
Why you should build a data warehouse
Learn the argument for building a data warehouse, why building one takes time and how to sharpen your data warehousing skills. Continue Reading
-
Responsibilities of the information architect
Learn the core responsibilities of the information architect beyond the scope of the business intelligence (BI) team. Continue Reading
-
How to maintain data quality and provide high quality information management and analysis
Data quality and governance expert David Loshin says maintaining data quality and providing high quality information management and analysis are based on a mutual data governance model. Continue Reading
-
Data-as-a-service, explained and defined
Data integration expert Jill Dyche defines data-as-a service (DaaS) and offers her view on outsourcing data. Continue Reading
-
ETL tools defined
ETL tools offer functionality to extract, transform and load data from one system into another system, but our expert advises they're not optimal for application-to-application communication. Continue Reading
-
Business intelligence and data warehousing team structure
Business intelligence and data warehousing teams are constructed differently, but most are placed within the IT department and include some basic, common roles. Continue Reading
-
Operational data stores: ODSs join the debate between data marts and data warehouses
The main feature of operational data stores is the real-time nature of the data. However, our expert advises that ODSs are not for everyone. Continue Reading
-
Data export command: Migration from a DB2 table to a flat file
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a database to an operating system file, which, our expert explains, can be in one of several external ... Continue Reading
-
Resources on creating and supporting BLOBs in DB2
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
-
MDM and business rules management
Expert Jill Dyche explains the role of master data management (MDM) in business rules management. Business rules, she says, should leverage master data when they need to. Continue Reading
-
Data mart vs. data warehouse
Craig Mullins explains various definitions of a data mart and sheds some light on the complexity of its relation to a data warehouse. Continue Reading
-
VSAM to DB2: Before you convert
There are reasons to convert from VSAM to DB2 -- and there are reasons not to. Find out what Craig Mullins has to say about a VSAM to DB2 migration project. Continue Reading
-
Steps to becoming a data warehouse architect (DWA)
Want to become a data warehouse architect (DWA)? Our expert recommends learning SQL as the first step. Continue Reading
-
A slow ETL process: Is there a 'best' ETL tool for a SYBASE IQ database?
-
Ralph Kimball vs. Bill Inmon approaches to data warehouse design
Learn about the debate between the Ralph Kimball and Bill Inmon approaches to data warehouse design. Continue Reading
-
VSAM vs. DB2
-
The path to an executable DB2 program
-
POS vs. EDI
-
How to limit the number of records in a cursor using DB2 native SQL?
-
How can I find the DB2 version and release level info in my CICS program?
-
Limiting the number of records in a SELECT statement
-
Multiplying fields from different tables
-
Difference between BI in the public sector and private sector
Find out the major difference between business intelligence (BI) in the public sector and BI in the private sector and get an expert's take on trends for those using BI in the public sector. Continue Reading
-
Facts about Packet Sniffing and Spoofing