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;

How many tables can you join in v2r5?

850

---

Explain teradata vs. Redshift?

809

---

What are the various indexes in teradata?

812

---

What do high confidence, low confidence and no confidence mean in explain plan?

839

---

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

816

---

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

779

---

Explain BYNET.

812

---

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

837

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

804

---

How would you load a very large file in teradata in general?

822

---

Discuss the advantages of using partitioned primary index in a query?

769

---

What are the 5 phases in a multiload utility?

844

---

Explain Teradata performance tuning and optimization?

957

---

What is meant by a node?

842

---

When tpump is used instead of multiload?

880

---