I am new to working with Teradata. I tried searching the forums for how to create a batch file to initiate a MultiLoad script but was not very successful. I would like to use Windows scheduler to kick off a MultiLoad script to populate tables over night.
Does anyone have an example of a batch file initiating MultiLoad?
Also I initially used OLELoad and FastLoad to load the staging table. I am using MS Access as a passthrough for the Oracle tables I am staging. I would like to now create a scheduled ETL with MultiLoad to refresh the tables over night.
Any suggestions on how to get started on this would be great.
Thanks in advance!