Reset sequence no for indirect file loading after each file load

[AtulGG]

Hi,
In my mapping i use sequnce generator to generate row numbers to load data from .csv file, based on these numbers i will filter out data. Now in workflow i use indirect file load to load multiple files issue is once first file is loaded i want to reset the sequnce number to one else data from other files will never be filtered.

br
atul

 

[blom0344]

The correct way would be to use a non-reusable seq generator and select the reset option. However, resetting is only achieved when a new session is started.
So obviously you need to spread the loading over multiple sessions..

Ties Blom