Page 1 of 1
porting utilities
Posted: Fri Jan 28, 2005 4:26 am
by SREEPRABHA
sir,
i am trying to import informatica mappings to datastage. in between while exporting from informatica to xml format i encounterd powrmart.dtd error due to which i couldnt get the xml page. i tried to open it in wordpad. how can i manuaaly convert the informatica xml format to datastage format.
Posted: Fri Jan 28, 2005 4:43 am
by Sainath.Srinivasan
This leads to a topic already discussed in this forum a few days ago.
The overall consent was that using 'MetaStage' tool you may be able to port the table defn.s and other structure meta-data but not the jobs and process metadata, which is more proprietary to the tool.
Posted: Fri Jan 28, 2005 9:11 am
by kcbland
You cannot take an Powermart/center mapping and load it into DataStage. There is no conversion tool either.
Re: porting utilities
Posted: Fri Jan 28, 2005 10:22 am
by peternolan9
SREEPRABHA wrote:sir,
i am trying to import informatica mappings to datastage. in between while exporting from informatica to xml format i encounterd powrmart.dtd error due to which i couldnt get the xml page. i tried to open it in wordpad. how can i manuaaly convert the informatica xml format to datastage format.
Hi SREEPRABHA,
if you are trying to get an INFA job to run unde DS through some kind of automatic mapping it is very difficult to do and we haven't seen anyone interested in paying to build such a utility......today it is a re-write from scratch......
Posted: Fri Jan 28, 2005 5:03 pm
by ray.wurlod
Even PeopleSoft were able to be convinced that it couldn't be automated. And they do have buckets of money they could have thrown at it.