DSXchange

My vote goes for the integration of Change Data Delivery. IMO, this is way more advanced than the Oracle GoldenGate or Informatica product offerings.

From the What's New page: InfoSphere Information Server is also now available for Public Cloud environments (via the IBM PureApplication Service on SoftLayer) Yay, DataStage in the cloud so I can finally run a demo or learning version at home. (just as soon as the service on SoftLayer moves out of b...

Here's a Redbook that explains the differences between the Connector and Enterprise stages: Redbook - InfoSphere DataStage Parallel Framework Standard Practices http://www.redbooks.ibm.com/abstracts/sg247830.html See Chapter 14 "Connector stage guidelines" It details the LOB support, rejec...

I need to find jobs that use certain tables, but the table definitions are not imported into the repository. Instead, each table is coded in a Dynamic RDBMS stage with the stage name the same as the table name. The problem is that neither Quick Find or Advanced Find is finding the jobs with the stag...

Note that there are two different products: 1) Change Data Capture - intended as a stand-alone product for transferring data from the source database to the target database 2) Change Data Delivery - intended to be used with DataStage for transferring data from the source database into a DataStage jo...

Only the BO Metadata Manager tool can show you the lineage of data elements at the BO report level. Dump the IBM tool and buy the BO tool.

Please note there are two separate products from IBM depending on your needs: 1) Change Data Capture - intended as a stand-alone product for transferring data from the source database to the target database 2) Change Data Delivery - intended to be used with DataStage for transferring data from the s...

Who approves new terms and definitions? Will multiple users from the line of business input the new terms or will an oversight group review and approve the metadata? The approvers should have private access to the terms to review them in meetings, get sign-off, etc. before the terms are released to ...

In addition to what others have stated above, I recommend attending the IBM Information On Demand conference which is held every October in Las Vegas. There are some very good DataStage-specific sessions at this conference, plus opportunities to learn about the other Information Server products. You...

Assuming you will be interviewing the candidate in a group interview with other non-technical people, I advise starting with basic, clear questions with definite right/wrong answers and then move into the more complex questions. Script out these questions, include the answers with some context and d...

I would start with the DataStage Redbooks and Teradata books from Cerulium Corporation.

Redbook - InfoSphere DataStage Parallel Framework Standard Practices

Redbook - IBM InfoSphere DataStage Data Flow and Job Design

Eric - thanks for good wishes and the information on the free certification with IBM premium support. I was not aware of that program, but did some research and found this link: http://www-304.ibm.com/webapp/set2/sas/f/handbook/offerings.html#5 IBM Software Accelerated Value Program To further evolv...

InfoSphere Change Data Capture can scrape the SQL Server transaction logs and replicate the data to DB2.

http://www-01.ibm.com/software/data/inf ... a-capture/

You need to apply at least Fix Pack 1.

http://www-01.ibm.com/support/docview.w ... JPZ&mync=E

We had to apply the DataDirect 6.0 upgrade to get DataStage 8.1 on AIX to work with the SQL Server 2008 datetime2 data type. I think the DataDirect 6.1 drivers were just released. What version are you using?