Home » Developer & Programmer » Data Integration » Informatica sequence nightmare!
Informatica sequence nightmare! [message #132940] Tue, 16 August 2005 23:00 Go to next message
tommy.liu
Messages: 1
Registered: August 2005
Junior Member

I want to immigrate my Informatica Mapping from Development enviroment to Sit enviroment, but meet difficulties.
U know in Mapping, there is a component - Sequence generator. If i copy the mapping to sit evn. i have to change the start value manually in the mapping to avoid confilicting with the existed value in SIT env. U know everytimes, when i reset the sequence start value, i should check the current value in the SIT evn. and then validate the mapping and workflow.
It is really a nightmare for us for I want to deploy the mapping from Development env. to SIT env. automatically, not manually.

Do u have any good ideas to solve this problem?
pls advice!
Re: Informatica sequence nightmare! [message #157334 is a reply to message #132940] Wed, 01 February 2006 12:15 Go to previous message
jeffbear
Messages: 1
Registered: February 2006
Location: switzerland
Junior Member
Hello Tommy, I do not know if you got round your problem yet, it has been a while, but anyway ...
you need to use the re-use option for the sequence generator when you migrate between life-cycle levels. With informatica 7 or higher you can use PMREP to export and import objects in batch. When importing you need to supply an object import control file which contains a section tellin pmrep how to resolve conflicts (normally encountered when an object already exists). the informatica help (search for PMREP) contains lots of help on formatting and providing the control file, but you need to make sure your 'resolveconflict' section looks like this
<RESOLVECONFLICT>
<TYPEOBJECT OBJECTTYPENAME="WORKFLOW" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="WORKLET" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="SESSION" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="MAPPING" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="MAPPLET" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Source definition" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Target definition" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Expression" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Filter" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Aggregator" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Rank" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Normalizer" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Router" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Sequence" RESOLUTION="REUSE"/>
<TYPEOBJECT OBJECTTYPENAME="Sorter" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="update strategy" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Custom Transformation" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Lookup Procedure" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Transaction control" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Stored Procedure" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="External Procedure" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Joiner" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="SessionConfig" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Email" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Command" RESOLUTION="REPLACE"/>
<TYPEOBJECT OBJECTTYPENAME="Scheduler" RESOLUTION="REPLACE"/>
</RESOLVECONFLICT>

Have fun with that, Jeffbear.
Previous Topic: run_my_owb_stuff hangs
Next Topic: difference between connected / unconnected lookup
Goto Forum:
  


Current Time: Fri Mar 29 01:38:07 CDT 2024