The answer number 5 for relational database objects only.
if the source is flat file we don't generate any SQL query in the source qualifier.
then we are using the following way,
seqgen
|
sd-->sq-->expr-->filter--> td.
in the filter condition expression we take nextval<=52000.