TERADATA -- How to Import and Export data to text file in TERADATA

How to Import and Export data to text file in TERADATA à To do this process first has to set some properties of TERADATA environment. Go to Tools in menu bar – go to Options – go to Export/Import tab --- change the property ------ Use this delimiter between columns (|), here I used PIPE Instead of PIPE based on the requirement use what you want. Note: - If your column data having existing delimiter mean, need to do some update in the columns. Because if you are using the...

Read More »

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server.

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server. Actually in the SQL server data base the spaces are looking like empty string only. For the first time all peoples will think of its space kind and will use LTRIM () & RTRIM () functions. It will not clear the tabs space and all. So this type of issue...

Read More »

Teradata Fast Load Script to load data from text file to Table

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=...

Read More »

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,...

Read More »

Comparing the two excel sheets using MACRO

Comparing the two excel sheets using MACRO Step1:- Create one sample text file with data like below Sno|EmployeeId|EmployeeName 1|23423|krishnaRaju 2|32423|Ranja 3|45653|venkat  Step2:- Create one sample text file with different data like below Sno|EmployeeId|EmployeeName 1|23423|krishnaRaju 2|7456|Ranja 3|45653|yhy Step3:- Create one excel file and click Alt+F11 to display the macro space the past the below code Sub Button1_Click() 'Declare variables here Dim sh As Long Dim...

Read More »