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 a clique?

1011

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017

---

Why managing the data is important?

957

---

What is a level of granularity of a fact table?

1071

---

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

980

---

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

1057

---

Describe primary index in teradata. And what are the available primary index types?

937

---

Difference between multiload and tpump?

1039

---

What interface is used to connect to windows based applications?

1037

---

How is MLOAD Client System restarted after execution?

1057

---

What are the enhanced features in teradata v2r5 and v2r6?

1078

---

Explain how spool space is used.

1018

---

What are teradata utilities?

1033

---

What do you mean by caching in teradata?

995

---

What are the various etl tools in the market?

1016

---