Skip to main content
Question

How to write the feature classes with no records from an Oracle Reader to the Fgdb writer dynamically?

  • December 9, 2025
  • 5 replies
  • 78 views

bhavyagandhi
Contributor
Forum|alt.badge.img+6

I am reading the feature classes and tables from an Oracle Reader, and many of those are not having any records, the tables are empty. But I want all of those in my ESRI FGDB output which I am using in the Feature Writer dynamically. How to achieve this? Any leads?

5 replies

salvaleonrp
Enthusiast
Forum|alt.badge.img+20
  • Enthusiast
  • December 9, 2025

A nofeaturestester transformer is the way to do it. I have built one but I need to look for it,


salvaleonrp
Enthusiast
Forum|alt.badge.img+20
  • Enthusiast
  • December 9, 2025

Found it…. you just need to wire it to your exact workflow. The logic is there.


bhavyagandhi
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • December 10, 2025

Found it…. you just need to wire it to your exact workflow. The logic is there.

It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.

Is there a way where it can work dynamically?


salvaleonrp
Enthusiast
Forum|alt.badge.img+20
  • Enthusiast
  • December 10, 2025

Found it…. you just need to wire it to your exact workflow. The logic is there.

It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.

Is there a way where it can work dynamically?

Please show a screenshot of your workspace or share your workspace, if you can.

Did you use the format parameter fme_feature_type from the source tables as dynamic feature class names in the destination FGDB feature classes or tables?

BTW, your comment in the Community post took several hours to appear in this question, after I received an email notification from the Safe Community site. Other notifications I received today were instant. I found that weird. I’ve been clicking on the email link the whole morning to see read this comment.


bhavyagandhi
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • December 11, 2025

Found it…. you just need to wire it to your exact workflow. The logic is there.

It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.

Is there a way where it can work dynamically?

Please show a screenshot of your workspace or share your workspace, if you can.

Did you use the format parameter fme_feature_type from the source tables as dynamic feature class names in the destination FGDB feature classes or tables?

BTW, your comment in the Community post took several hours to appear in this question, after I received an email notification from the Safe Community site. Other notifications I received today were instant. I found that weird. I’ve been clicking on the email link the whole morning to see read this comment.

I am also finding this weird, whenever I am adding comment it's saying The Moderator will review it first and then it will appear. Even I tried to add 2-3 comments where I shown the screenshots as well, but seems like they did not even appear

I will share my workspace meanwhile I also need help if you can provide on How to read tables from Oracle Feature Reader if the Table Names to read is coming from an attribute from an excel file, I am trying some options but they are not working