DSXchange

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

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.

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"

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

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.

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

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.

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

Thank you, priyadarshikunal.
It really worked!!