Answer Posted / yuvaevergreen

Adding to above,assuming usage of a simple restart table,
below logic can be used. Below sql will not take care of
insert or delete statement failure. If the update statement
fails, the script would be restarted from update statement.
If the insert or delete statements fail, the script
would be started from insert statement.



bteq << EOF

.logon tdpid/user,password;

SELECT * FROM RESTART_TABLE WHERE STATUS='RESTART';
IF .ACTIVITYCOUNT=1 THEN .GOTO UPDTDML;
IF .ACTIVITYCOUNT=0 THEN .GOTO INSDML;

.label INSDML;
INSERT STATEMENT;

.IF ERRORCODE <> 0 THEN .EXIT;

.label DELDML;
DELETE STATEMENT;

.IF ERRORCODE <> 0 THEN .EXIT;

.LABEL UPDTDML;
UPDATE STATEMENT;

.IF ERRORCODE <> 0 THEN .GO TO REST;

.IF ERRORCODE = 0 THEN .GO TO REST1;

.LABEL REST;
DEL FROM RESTART_TABLE;
INSERT INTO RESTART_TABLE ('RESTART');
.EXIT;

.LABEL REST1;
DEL FROM RESTART_TABLE;
.EXIT;

.EOF

What is the purpose of using case expression in teradata?

1017

---

How do you determine the number of sessions?

1064

---

List out all forms of LOCKS that are available in Teradata.

969

---

What are default access rights in teradata? What explicit right can be given to a user?

1112

---

List the logical and conditional operators that are used with teradata along with their meanings?

1003

---

What interface is used to connect to windows based applications?

1115

---

What is stored procedure in teradata?

1030

---

What is the use of having index on table?

1003

---

How will you solve the problem that occurs during update?

1055

---

Explain parsing engine in teradata?

1092

---

Name the five phases that come under MultiLoad Utility.

988

---

What is node? How many nodes and amps used in your previous project?

1110

---

Explain teradata utilities. What is multiload, fast load, tpump?

1008

---

what are the day to day activities of teradata DBA ?

5824

---

Explain and compare pros and cons of snow flake schemas?

1035

---