Teradata Fast Load
Script to load data from text file to Table
Step1:- Create one sample text file Lokesh.txt
Type: vi Lokesh.txt
= i
à
write the text file with below sample data
101,Mike,James,1980-01-05,2010-03-01,1
102,Robert,Williams,1983-03-05,2010-09-01,1
103,Peter,Paul,1983-04-01,2009-02-12,2
104,Alex,Stuart,1984-11-06,2014-01-01,2
105,Robert,James,1984-12-01,2015-03-09,3
= :wq (will save the file data and close)
Step2:- Create one shell script Lokesh.sh
type=...
Friday, February 17, 2017
Unix login process and accessing steps
Unix login process
and accessing steps
-- Go to Putty software – Give Host Name (Connection Type:-SSH)à Click Load àWill open black screen
-- Give credentials to login
Once login to UNIX type like below
1) su – (user name)
Ex: - su – WDIF
2) To go for
specific environment
Prod (Production)
3) Change the
location path
Cd (folder name)
4) To see the
list of all files in the folder
ls –ltr
5) Creating Text
file
vi Lokesh.txt
file will open for
edit,...
Subscribe to:
Posts (Atom)