Topic
  • 2 replies
  • Latest Post - ‏2005-06-17T15:26:39Z by SystemAdmin
SystemAdmin
SystemAdmin
510 Posts

Pinned topic DataStage <-> Informatica Conversion

‏2005-06-17T06:29:44Z |
Can MetaStage be used to convert Informatica programs to DataStage's and vice versa? Any idea, considerations, constraints would be much appreciated. Thanks in advance
Updated on 2005-06-17T15:26:39Z at 2005-06-17T15:26:39Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    510 Posts

    Re: DataStage <-> Informatica Conversion

    ‏2005-06-17T11:51:12Z  
    The PowerCenter 5.0 MetaBroker lets you import meta data from Informatica into MetaStage and DataStage. Here's some information from the technical bulletin:

    "The primary function of the PowerCenter 5.0 MetaBroker is to let you view and study PowerCenter meta data in MetaStage. You can, for example, use Impact Analysis to view imported PowerCenter objects and the relationships between them.
    "PowerCenter and DataStage have different paradigms, and not all their meta data classes overlap. For this reason, the PowerCenter 5.0 MetaBroker does not enable you to transfer jobs from PowerCenter to DataStage and then run the jobs on DataStage. You cannot automatically convert your PowerCenter Mappings into functional DataStage jobs.
    "When you use the PowerCenter 5.0 MetaBroker to import Sources, Targets and Transformations into DataStage, these objects are displayed as external stage types in DataStage, not as functioning stages that can be compiled into an executable job. This provides a visual presentation of PowerCenter meta data in DataStage terms that can be helpful in creating an equivalent job in DataStage.
    "Once you study the PowerCenter Transformations and Mappings in MetaStage, you can selectively export objects to DataStage to use as models or templates when you design a new DataStage job.

    ...

    "Certain PowerCenter meta data classes, such as Transformation Object, Source, and Mapplet, do not have equivalents in the DataStage paradigm. These classes are viewable in MetaStage.
    "The PowerCenter 5.0 MetaBroker model also includes a set of standard data definition classes, including Server, Database, Schema, Table, and Column. These classes are also viewable in MetaStage."
  • SystemAdmin
    SystemAdmin
    510 Posts

    Re: DataStage <-> Informatica Conversion

    ‏2005-06-17T15:26:39Z  
    Can MetaStage be used to convert Informatica programs to DataStage's and vice versa? Any idea, considerations, constraints would be much appreciated. Thanks in advance[/quote:a7aa206e32]

    The MetaBroker wasn't really designed for this usage, and you will not have much success with an attempt. The good news is that the Advanced Consulting Group (ACG) has developed a utility that will perform such conversions. It has been utilized at several customer sites to help them migrate from Informatica PowerCenter to DataStage with great success. This is the same utility that PeopleSoft used to convert their several thousand INFA maps to DataStage jobs.

    I suggest that you contact the leader of the ACG team for more information. His name is Tim Davis, and he can be reached at davisti@us.ibm.com.

    -Nathan Bobbin