Ask the Experts
Ask the Experts
-
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?
-
MDM vs. CDI
Jill, glad to see you'll be hanging around on TechTarget for a few weeks. I think people will be bleeding your brain for substantive advice. I'll certainly take my shot. Here's my question: Everyone -- including you -- has been saying "plan MDM, but... Continue Reading
-
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
-
How can I find all of the ABAP programs for BW?
-
DB2/UDB on Unix/Linux vs. DB2/OS/390
-
What difference does a 1 = 1 predicate make?
-
VSAM vs. DB2
-
How and when to use DB2 scrollable cursors
-
Roles and responsibilities for new MIS unit handling data quality and BI
Read advice on sorting out the roles and responsibilities of an MIS unit that is tasked with handling data quality, business intelligence and reporting. Continue Reading
-
Why would a company buy Cognos software on top of Oracle reporting?
According to experts, Oracle has built in a number of reporting facilities, but they are not as mature as Cognos or Business Objects (BO). Find out if you need Cognos software on top of Oracle reporting. Continue Reading
-
The benefits and drawbacks of DB2 V8
-
Who is using the DB2 table?
-
Parallel processing against a DB2 table
-
What is the role of a DBA?
-
The maximum length of a VARCHAR item
-
The path to an executable DB2 program
-
Cost vs. advantage of moving from IMS DB to DB2
-
Rollback changes coming undone
-
Why deadlocks occur and what to do about them
-
Using an open cursor to scroll forward and backward
-
POS vs. EDI
-
How does DB2 manage the memory allocations/deallocations in an AIX environment?
-
Console vs. GUI-based mainframe applications
-
Can you help me with this query?
-
How to limit the number of records in a cursor using DB2 native SQL?
-
Can a search-condition in CASE expression contain a subselect?
Find out if a search-condition in CASE expression contain a subselect and learn a workaround to make this happen. Continue Reading
-
How can I find the DB2 version and release level info in my CICS program?
-
QMF versus SPUFI
-
DB2 versus Sybase
-
How can I insert multiple rows in a DB2 table?
Learn how to insert multiple rows into a DB2 table using one INSERT statement in this tip from Craig Mullins. Continue Reading
-
An overview of normalization forms
Our expert defines Fourth Normal Form and Fifth Normal Form. Continue Reading
-
Primary keys in DB2
-
Paging through DB2 records
-
How to prevent contention issues with batch and online programs with 24x7 availibility
-
Equivalent DB2 syntax for the Oracle DECODE function
-
Limiting the number of records in a SELECT statement
-
Using TRACKMOD NO in a tablespace definition
-
Different date formats in CLP and Command Center
-
Multiplying fields from different tables
-
What are e-checks?
-
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
-
E-Payment security and systems