Source is department table, and department number get populated by some other system.
ODI read the department table, find the distinct department number from column on run time.
Create the separate files based on how many department no distinct values in the table.
If the table has 3 distinct value, it will create the 3 separate file.
If the table has 4 distinct value, it will create the 4 separate file.
Output file name we can add the distinct value in the name of the file.
For example if I have 10, 20, 30 department table, I have to create the 3 output files from the source table using variable. In future department number might be added and file should get created automatically. Could you please advise which module I need to look to address this requirement? Or if you can send me the documentation steps that would be really useful.
Thanks a lot.