Hi @sandeepchettu, would this help for you, which is for me the base of the Intergraph component model:

select g3e_feature.g3e_fno
     , g3e_feature.g3e_username
     ,  g3e_feature.g3e_tooltip
     ,  g3e_component.g3e_cno
     ,  g3e_component.g3e_username
     ,  g3e_component.g3e_table
     ,  g3e_component.g3e_tooltip
     ,  g3e_component.g3e_lrno
     ,  g3e_component.g3e_type
   from g3e_featurecomponent
   inner join g3e_feature on g3e_feature.g3e_fno = g3e_featurecomponent.g3e_fno
   inner join g3e_component on g3e_component.g3e_cno = g3e_featurecomponent.g3e_cno
order by g3e_component.g3e_cno;

You might find more on this subject on this location.

select g3e_feature.g3e_fno
     , g3e_feature.g3e_username
     ,  g3e_feature.g3e_tooltip
     ,  g3e_component.g3e_cno
     ,  g3e_component.g3e_username
     ,  g3e_component.g3e_table
     ,  g3e_component.g3e_tooltip
     ,  g3e_component.g3e_lrno
     ,  g3e_component.g3e_type
   from g3e_featurecomponent
   inner join g3e_feature on g3e_feature.g3e_fno = g3e_featurecomponent.g3e_fno
   inner join g3e_component on g3e_component.g3e_cno = g3e_featurecomponent.g3e_cno
order by g3e_component.g3e_cno;

I need to migrate data from integraph gtech to fgdb using FME,here using above query provided can i map feature to feature respectively. 

Hi, that's An impressive job. You will probably start reading Oracle spatial and using g3e_geometry as geometry. You will need every component of the query above and translate it to fgdb feature. A SchemaMapper may come in handy for this, I suppose there is a large number of features to migrate? You could throw in another join to the g3e_attribute table to see field properties. Older versions use Oracle spatial relational. That is, IF your customer is using Oracle.