DSXchange

Hi All, Currently on V 7.5 on Windows and planning to migrate to 9.1.2. We have Server jobs and Server Routines only and plan to use the same post migration! We have one Datastage Project that houses all the Hash and Universe Files including SDkSequences (but No Jobs) and these are referenced using ...

1. If we have 2 Engine Tiers, can we restrict jobs from a specific project to run on a particular engine only while other project(s) to run on the 2nd Engine, by leveraging the Configuration file? 2. If we want to add a new Engine tier, does this need a Re-Install? 3. Any other considerations if we ...

Yes we plan to ensure that job optimization and other techniques as you mentioned are validated first before we decide on either approach. If we have Services and Engine Tier separated out, I assume we should be looking at more CPU/Physical Memory on the Engine, as this will do most of the processin...

For 1 - Confirmed that Quality Stage License is inbuilt when we buy Infosphere Information Server with Datastage.

For 2 - Will update once I get this information confirmed

Hi All, Enterprise Edition - v8.7 We are hitting a performance bottleneck with multiple projects using the same ETL server for Data Integration requirement to load to both OLTP and DW databases. Current topology is all 3 tiers on same Server! Approach 1 (post job optimization and environment upgrade...

Hi, I have a couple of licensing questions 1. When we purchase the Infosphere Information Server Enterprise Edition for Datastage, does it automatically include Quality Stage or there is a separate license to use it in Datastage Jobs? 2. Can we buy "Server" License or "Parallel" ...

The programs are written in Universe but invoked from Datastage

Thanks Ray..how about sizing the CPU (count) and Memory requirements..hence I mentioned the data volumes and the complexity of transformation

To give a context - we are expecting about:

Annual Data Growth - 10-15%
15M rows to be processed daily
Medium level transformation rules complexity
Sources - Files and RDBMS
Target - Netezza

Hi All, We are in the process of sizing a datastage environment. What are the inputs needed that would help in arriving at a reasonably close hardware requirements estimation..No of Cores, Memory (I understand it cannot not be accurate but in the ballpark) e.g Data Volumes Available Load Window with...

Hi,
we are currently, v 7.5, calling some Universe Programs from batch jobs from the Before Job Routine. Will we be able to call these same Universe Applications from version 9.1.2 (post migration)?

or we have to rebuild this logic in some other way and then use in the new version?

Thanks,
VN

Hi All, I see in version 9.1 (Server jobs) Unidata 6 stage has been superseded by Unidata stage. We need to connect to Unidata 7.3.4, does it support this Unidata version? Also does it use the UNIAPI to connect to the Unidata Server from Datastage? If yes any specific settings we need to make on Dat...

Hi, We are on Windows on v7.5.3 and are planning to migrate to Information Server V9.1.2. Currently the Datastage Engine is 32-bit where as I understand in 9.1.2 it will be 64-Bit (or 32-bit?) Are there any potential issues due to change in bitness that could impact the export/import/compile of the ...

Hi All, When we purchase the Information Server 9.1 License, does it include both the Server and Parallel Engine? I mean we will be able to design both Server and Parallel jobs If we would like to use only Server jobs, is there a separate license instead of buying the package that includes both or t...

Hi, Is there any specific Source Code Control tool that works best with Information Server V9.1 (mainly usage is Datastage)? We are considering Rational suite - ClearQuest and ClearCase Any suggestions around the tool we can use especially considering the cost and ease of use Does Microsoft Team Fou...