Answer Posted / yuvaevergreen

BTEQ or multiload(loaded tables) or fastload (empty table)
can be used to load a single row. But BTEQ would be a good
option if you load a single row from a file.Below is a example.

//STEP1 EXEC PGM=BTQMAIN
//LOGON DD DSN=TEST.LOGON(DEVLOGON),DISP=SHR
//SYSIN DD DSN=TEST.PARMLIB(BTEQ1),DISP=SHR

//*TEST.PARMLIB(BTEQ1)

BTEQ MAINFRAME IMPORT SCRIPT EXAMPLE – DATA MODE

.SESSIONS 1

.RUN FILE LOGON
.IMPORT DATA DDNAME=REPORT
REPEAT *
USING
EMP_NO (INTEGER)
INSERT INTO EMPLOYEE
VALUES
(:EMP_NO);

.QUIT;

What is teradata?

1151

---

What is the syntax for case when statement?

1144

---

What's the difference between timestamp (0) and timestamp (6)?

1196

---

What are the different table types that are supported by teradata?

1003

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1166

---

How can we check the version of Teradata that we are using currently?

1069

---

What do you mean by parsing?

1113

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113

---

Highlight the points of differences between the database and user in Teradata.

1109

---

Explain the meaning of Amp?

1153

---

What tools would you use for that?

1109

---

What is the use of fallback?

996

---

Is multi insert ansi standard?

2207

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2420

---

What is meant by Teradata Gateway?

1060

---