Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI create the run time CSV/XLS file based on distinct value in the source Data.

User_HG7TTJun 11 2021 — edited Jun 11 2021

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.

Comments

Post Details