I have to load some [9000 rows] data from SQL server to teradata table . These are options i am left with :-
1. I have TD Studio Express 15 with teradata 14.
2. I dont have UNIX or any other environment to load data
Can i use windows cmd prompt for loading data using MLOAD or FLOAD ?
You can use. One way is to write your script in notepad and store somewhere and execute. Make sure you are in the path or you configure path of mload/fload.
I m more comfortable in Unix/Linux , using find :). In windows, you can just browse with a mouse and check where Teradata stuff is there.
It can be something like in this link only for the path, example:
A simple way of finding the utilities in our system would be - go to command prompt and type below commnds -
These command would give the version of the utilities installed. can come out of the utilitiy prompt by pressing ctr+c