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 type of indexing mechanism do we need to use for a typical data warehouse?

1155

---

How to run a query in teradata?

1060

---

How to load specific no.of records using bteq, or fastload,or multiload

1738

---

What is the use of teradata system software?

1031

---

In the Primary Index, what is the score of AMPs that are actively involved?

1061

---

What is the syntax for case when statement?

1119

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

1018

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1185

---

What is the purpose of joins in teradata?

1160

---

Define views in teradata with syntax.

1068

---

What do you mean by tpt in teradata?

1017

---

What are the different softwares used with their functions in teradata?

1009

---

What are the steps involved after the disk manager passes the request?

1107

---

If RDBMS is halted what will you do ?

2152

---

Name the five phases that come under MultiLoad Utility.

982

---