Parameter Provision to read values from file

devsonali · Post by **devsonali** » Thu Apr 25, 2013 11:01 am

Hello All

I am trying to load a set of tables from one database to another (simple straight load) , However at this point I am using RCP and manually providing table names (as parameter value) for each of the tables being loaded (one at a time)

I wanted to see if there is a way to automate this process by reading the table names from a file (just curious)

I have no clue how to search this issue in this forum so didn t try too hard .

Any ideas would be highly appreciated .
Thank you all for reading

ray.wurlod · Post by **ray.wurlod** » Thu Apr 25, 2013 12:45 pm

Click Search in the menu at the top of the page. Prefer an exact match search.

It IS possible to read the table names from a file.

devsonali · Post by **devsonali** » Thu Apr 25, 2013 12:57 pm

I am sorry - I meant I that I do not know "What phrase on which I need to search for this kind of scenario "

However I will try searching on "reading table names from file"

devsonali · Post by **devsonali** » Thu Apr 25, 2013 1:07 pm

Update I could not find the solution on this scenario post searching .

ray.wurlod · Post by **ray.wurlod** » Thu Apr 25, 2013 5:34 pm

OK, show us what you've tried, describe why and how it is not performing as expected, and describe how you've gone about your troubleshooting. Armed with all that information, we may be able to assist.

devsonali · Post by **devsonali** » Fri Apr 26, 2013 11:04 am

Sure
I tried to search on key words/phase "parameter value reading from file"
"table names from file"

What I am not sure is does it need a job sequencer to perform this kind of activity to start with or is there a way to simply point the parameter to a file (I don t see this option in 8.5 parameter properties )

What I have tried - Since I do not have a direction to follow and possibely test something at this point - I haven't been able to try anything.

I can test something only if I know how to approach (with what stages) .

Hope this makes sense.
Thank you

priyadarshikunal · Post by **priyadarshikunal** » Fri Apr 26, 2013 1:11 pm

all you need to do it put all the table names in a file delimited with some character say "|".

Run cat <filename> in the execute command activity and then use its output in a start loop activity (list loop with "|" as delimiter).

The counter variable holding one value at a time can be used as parameter in any downstream stage.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 26, 2013 3:40 pm

I actually meant for you to show us what you'd tried in regard to reading the table names from a file.

joycerecacho · Post by **joycerecacho** » Wed Apr 30, 2014 6:00 am

Thank you, priyadarshikunal.
It really worked!!