what is the database you are using , oracle or SQL server ?
Do you know which objects in the FDMEE schema are growing?
The FDMEE schema does contains the ODI work repository (unlike ERPI) where the ODI Operator logs are stored (which can take up a fair amount of space over time). One option to free some space might be to delete old sessions from the ODI Operator log. I'm not sure if you can do that via the ODI console though - you may need the ODI Studio to be able to easily delete old sessions from the ODI Operator.
It's Oracle database.
We can only notice that the table space is growing , we don't know which tables are growing, we're just adding more data load mappings and rules. I mean the normal work of FDMEE.
I'll check the ODI operator thing, so there's no setting from the FDMEE? I'm just thinking that as a permanent solution it shouldn't be that we have to manually go and delete some old sessions. Is there a more permanent solution?
With the joys of google and a bit of tinkering I've managed to put this together that lists objects in the current user's schema ordered by the space that they use in bytes
SELECT * FROM USER_SEGMENTS ORDER BY BYTES DESC;
If the tables taking up the most space are SNP_ tables then that's the ODI tables (SNP_SESS_TASK is one of the larger tables in my test system) and truncating the Operator logs might help. Otherwise we'd need to know which tables (or other objects) seem to be taking up the most room to be able to say what is contained in the table(s).
I don't think there are any settings to not record failed loads in FDMEE - a lot of info is stored in the FDMEE schema for auditing purposes.