- #SERVERJ JOBS IN DATASTAGE 7.5 PLUS#
- #SERVERJ JOBS IN DATASTAGE 7.5 FREE#
DataStage 7.5 also has new mobile device support that can administer the DataStage jobs via a palm pilot. The sequence job has an email stage that is easy to configure.
#SERVERJ JOBS IN DATASTAGE 7.5 PLUS#
They both support multiple views (business and technical) of metadata plus the functions you would expect such as impact analysis, semantics and data lineage.
It integrates closely with PowerCenter products. Informatica SuperGlue was released last year and is rated more highly by Gartner in the metadata field. It can import metadata from a wide range of databases and modeling tools and has a high degree of interaction with DataStage for operational metadata.
#SERVERJ JOBS IN DATASTAGE 7.5 FREE#
Ascential MetaStage comes bundled free with DataStage Enterprise and manages metadata via a hub and spoke architecture.
Ascential and Informatica both have robust metadata management products. The DataStage Best Practices course also provides training in DW loading with SCD and surrogate key techniques. DataStage 7.x releases have intelligent assistants (wizards) for creating the template jobs for each type of slowly changing dimension table loads. DataStage has some very good debugging facilities including the ability to step through a job link by link or row by row and watch data values as a job executes. SAP is a reseller of DataStage for SAP BW, PeopleSoft bundles DataStage in its EPM products. Both products have options for integrating with ERP systems such as SAP, PeopleSoft and Seibel but these come at a significant extra cost. Both products have an unlimited number of transformation functions since you can easily write your own using the command interface. DataStage comes with XML input, transformation and output stages. DataStage and Informatica support XML. This may not be the case with Informatica. You might end up extracting data from all the sources and putting them into a hash and start your transformation. Datastage does not perform very well with heterogeneous sources. For a simple project, you might end up having 3-4 times more jobs in Datastage than in Informatica. The job when compiled generates a Basic routine and bigger the routine is, slower the job performs. 
Datastage best practices calls for landing the data in between transformations and have smaller simpler job. 
You can tune the hash files to get an optimal performance.
Lookups are much faster in Datastage, because the way the hash files are built. Informatica is more visual, programmer friendly. Datastage is more powerful transformation engine by using functions (Oconv and IConv) and routines. This has both advantages and disadvantages. With the introduction of repository server, they have isolated the server calls with repository calls to reduce the load. Datastage is closely integrated with its repository (universe database). Comparison Between DataStage (Server Edition) and Informatica
0 kommentar(er)
