Robert Fruchtman

Data migration.
1. I need a script that will read a text file of database tables.
2. Loop through this list and call an ps1 file or a new file that will call a java jar file with parameters that will extract a .zip file which will create an out file of how many rows will be loaded in another step.
3. Call another ps1 script which will extract a .csv data file.
4. I need a script that will create proposed view of the table that will be created based on the .csv table.
5. I need a script to create the table based on specs.
6 load the table my calling oracle sql loader.

We already have a script that just needs to run for creating the view and table.

We just need to loop through all the tables choices to extract the expected values like row count, extract data, create view, table and load the data