DSXchange

Please create a process by which a new project named Globals can be created. This new project named Globals, should contain all the environment variables by default and projects should inherit this settings first and then the local settings. In addition, this project should be able to do much more ...

Please create a process by which a new project named Globals can be created. This new project named Globals, should contain all the environment variables by default and projects should inherit this settings first and then the local settings. In addition, this project should be able to do much more t...

kduke wrote:Never happen. That why they bought Cognos.

Gotcha. A feature best left to another tool to provide.

Thanks for the feedback!

chulett wrote:You seem to be having this conversation with yourself...

Yeah, I do like to argue with myself sometimes. But seriously, I am looking for opinions other than my own. Sorry about that.

How important is a core competency?

I think you have answered by question below.

Thanks and you folks are awesome.

ETL: More than Middleware?

I have a job which is loading data to 3 tables using Teradata mulitload stage and it is failed in Application phase.How to restart this job from Datastage? Contact your Teradata DBA and have them reset the load status of the tables and drop the error tables. Then, open the director application and ...

Part of EtlStats is a job to generate html reports. Give it any SQL statement and a ODBC DSN and it will generate the html report and email it as an attachment to any email address. This report stage should be able to consume multiple input links and be able to have headers, footers, labels, etc......

Please a new source SQL statement stage which can be used to run many SQL statements on a selected platform. For example, DB2, Oracle, Sybase, MSSQL, and Teradata. This source SQL stage should allow for many SQL statements to be run as their own batch by allowing statements to be added sequentially ...

Add a new target stage which can consume multiple input links and build a report similar to reports which can built in MS Access. This stage should be able to save the report in pdf format and html format. This should also allow the report to be emailed upon the report being built. This stage should...

Please add the capability of running before and after SQL statements within the stored procedure. This is important for specifying session level settings.

Thanks.

Please allow us to specify ANSI ON and ANSI OFF settings for Sybase and MSSQL in Stored Procedure Stage using the transaction mode drop down. This allows to not have duplicate DSN's for MSSQL with ANSI ON and ANSI OFF or from building this logic within the procedure. This is important for procedures...

Please add the capability of compiling jobs when doing an export from a project which is not protected. So, jobs which are not compiled when exporting will attempt to be compiled if this option is chosen. Thus, add a drop down: Export job designs with executables (compile if missing) Then, when doin...

Also, jobs must be written correctly to make use of these properties. That is, depending on partitioning methods employed, number of nodes, number of target stages and virtual target stages (that is number of nodes), this may not work properly. Thus, customers must create jobs correctly to make use ...