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;

Mention a few of the ETL tools that come under Teradata.

1131

---

What does Amp contain and what are all the operations that it performs?

1052

---

What is meant by a Clique?

1114

---

What are the functions involved in shared information architecture?

1121

---

what is object level locking ? where do appear this type of locking ?

3538

---

What are teradata utilities?

1155

---

What are the newly developed features of Teradata?

1081

---

Explain the types of join supports by teradata?

1041

---

What is meant by a Virtual Disk?

1205

---

Explain the term 'database' related to relational database management system?

1037

---

Can we collect statistics on table level?

1092

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1075

---

What is the difference between union and union all in teradata?

1185

---

Explain BYNET.

1053

---

Difference between stored procedure and macro?

1217

---