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 the use of virtual processor connectivity in teradata?

957

---

What is a node in teradata?

950

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1063

---

What do you mean by parsing?

1064

---

What is a three-tier data warehouse?

1064

---

What are the 5 phases in a multiload utility?

993

---

What is the use of having index on table?

962

---

Explain and compare pros and cons of snow flake schemas?

990

---

List out some of the primary characteristics of teradata.

929

---

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

949

---

what are the uses of fact table and dimension table in banking project?

4503

---

What is the maximum number of dml can be coded in a multiload script?

1068

---

What is logical data model?

1158

---

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

976

---

How to run a query in teradata?

1018

---