Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ODI12c parsing data file name and storing in target
Is there means to take an input file name (to a mapping - our input files will have a process_id appended to end), parse out the process_id
and then take this info and use as input to a target column in the mapping?
Are there any blogs or whitepapers regarding this type of thing available?
Thank you!
Best Answer
Answers
-
-
Thanks very much I will look at those.
-
The variable FileName is not getting populated. I am using it as input to a mapping. Any ideas? thank you
-
Hi,
You have to create a package and add the variable (with the status Refresh Variable) and the mapping.
The variable may be assigned a value in the package or it may have a refreshing SQL statement.
Adrian
-
I have the variable and the mapping in the package and am running the scenario. The variable
I am using https://blogs.oracle.com/dataintegration/using-parameters-in-odi:-the-dynamic-file-name-example for instrucation on how to do this.
I have verified with a mapping that I can process (in mapping) the file which lives on the ODI server. So my model is setup correctly. I updated the resource name in the model
including the project code prefacing the filename. FileName is the my variable name.
thank you!
-
When you generate a scenario from the package you are asked if you want to include the variable in the scenario. So check the variable to be included in the scenario.
When you execute the scenario you are asked to provide a value for the variable: provide the file name.
Adrian
-
In odi package you have just declared the variable, its similar to declare section in pl/sql block.
You have to pass some value to it then only variable will holds some value and the package will run successfully.
Try to use the procedure to get the file name in the package and then link odi variable to it.
You package will be something like this
1) Odi procedure to get the file names
2) Odi variable
3) Odi mapping
Regards,
Pavan
-
Thank you for your response Adrian. I did check the box to include the variable when regenerating the scenario. I will not know the file name at run time. I have created a variable (FileName) to house a dynamic filename.
Deena
-
Pavan,
Are you saying that I need a procedure (also) to get the value of the variable?
Christopphe, in his article , https://blogs.oracle.com/dataintegration/using-parameters-in-odi:-the-dynamic-file-name-example
made no mention of needing a procedure to accomplish retrieving a dynamic filename. But, I see nothing from what I have written
to this point , that would be performing that part.
Deena
-
Hi,
In the blog you have mentioned they are passing file name dynamically during run time, they are not retrieving the file name.
But in your case you want to read the file name during run time.
You have to write ODI procedure to read the file name.
Regards,
Pavan