@rajask132 Below I've listed a couple of the resources available to you regarding extracting data from Smallworld:

• Working with GE Smallworld Databases: Starting point when working with FME & Smallworld

   

• FME and Smallworld Configuration Options: key resource for understanding your install and configuration options for the Smallworld reader/writer - referenced in the article above.
• Smallworld Tutorial: also referenced in the first article. The section Working with Alternatives or Versions in Smallworld has a brief overview of how to use a predicate to extract specific data from your Smallworld VMDS.

The GE Smallworld FME reader/writer plugin is somewhat limited on the types of join that are supported. In the tutorial referenced above, the section Join Fields in Smallworld describes the supported joins.

Another option would be using the Spatialbiz plugin for Smallworld.

That plugin works with the Database Edition of FME.

The plugin is able to customize the export, using Magik code.

Have a look at the options here: Spatialbiz Plugin