| Informatica sequence nightmare! [message #132940] |
Tue, 16 August 2005 23:00  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
