- 3,734,446 Users
- 2,246,973 Discussions
- 7,857,293 Comments
- 17.8K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 57 Insurance
- 533.3K On-Premises Infrastructure
- 137.3K Analytics Software
- 38.5K Application Development Software
- 5.1K Cloud Platform
- 109K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.7K Infrastructure Software
- 105K Integration
- 41.5K Security Software
ODI create the run time CSV/XLS file based on distinct value in the source Data.
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.