DSXchange

This may be heresy - but what analysis tool are your end users likely to use? I recently went to a presentation of Business Objects Data Integrator (formerly Acta) which appeared to have strong integration with Business Objects for building universes (metadata gathered in the ETL process could be us...

I'm a relative DW novice (having only worked on one significant project) but can also vouch for Kimball DW Lifecyle Toolkit book.... In our particular setup we are afforded the luxury of having a scheduled daily window when activity on the source databases in negligible - if your environment allows ...

We have a requirement to supply external clients with csv flat-files extracted from our DW which they will then build pivot tables over in Excel... Can anyone advise the easiest way to take the files that DS creates, zip them up and attach them to an e-mail and mail them out? As I see it I have two ...

Thanks for the input however the same connection worked fine earlier in the run of batch jobs and that the same job has run for weeks in succession without falling over. Thus I don't think we have a problem with the odbc.ini or the SHLIB_PATH as these are set correctly and we have done no configrati...

We are getting the following error sporadically: ccsourcedel..SrcCodesHash.IDENT1: |ccsourcedel..CCSrcCodes: DSD.BCIConnect connecting to p_vnu, call to SQLConnect failed. SQLSTATE=IM002, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver...