how to migrate assets and phases tables(joinrecords) and how to maintain relation ship with installation tables in smallworld.

For relations, Have you tried featuremerger?

Some info from our training materials:

The GE Smallworld writer can import join fields for text based joins fields and foreign key fields. Other types of join fields are not supported, Refer to the GE Smallworld documentation: Smallworld FME Translator Reference – section 4.5 Join Fields. You may have to make some fields visible using the Administration ACE application

FME can load simple joins. There are three types of joins that can be represented:

• Simple parent – child 1:0..n relationship, i.e. Town - Roundabout • Heterogeneous relationships. These are parent – child 1:0..n relationships, where there can be different parent objects. i.e. Office or Point of Interest may join to a Road Works object • Multiple child object joins. These parent – child relationships have one parent but multiple child objects

In summary, to build a simple join relationship you need to set the foreign key on the child table to match the primary key of the parent table. As @pratap suggests, the FeatureMerger transformer is a great way to do that.

I hope this helps. If not, let me know and I will get a Smallworld expert at Safe to take a look at your question.

If you do not have access to the FME SmallWorld Edition, the Spatialbiz FME SmallWorld plug-in is a good alternative. The plug-in allow interaction between FME and SmallWorld (reading and writing) and supports JOIN fields in many ways.

For more information:

http://www.spatialbiz.com/spatialbiz-plug-in.html