Answer Posted / charan

Journal is prevents from image failure.
these are 3 types
they are
1.Recovery journal 2. Transient Journal 3.permanent Journal
Images are defined into 4 types based on Journals
they are,
1.single image 2.Dual image 3.Before Image 4.After Image

Single image: It Takes the one copy of the data
Dual Image : It Takes 2 copies of data
Before Image: It takes copy of the data before operation
After Image : it takes copy of the data after operation

Recovery Journal:
It will useful for Recovery the data.Suppose if there is any fail will happen in AMP

Transient Journal:
It will useful for the data if there is any operation fails means go to the previous step.

Permanent journal:
It will takes the data for Partial and full recovery

for,
Partial Recovery:
B.I+(Mon to Sun) A.I

Full Recovery:
B.I.+(Mon to Wed) A.I.

What are the joins in teradata?

1069

---

What is meant by a Parsing Engine?

1230

---

How is MLOAD Client System restarted after execution?

1200

---

Explain the most common data types used in teradata?

1120

---

How do you define Teradata?

1082

---

What is stored procedure in teradata?

1082

---

What are the various etl tools in the market?

1120

---

What do you mean by teradata intelliflex?

1164

---

What are the different functions performed in development phase?

1128

---

What is the difference between teradata and basic rdbms?

1070

---

What is meant by a Clique?

1111

---

How is the teradata different from oracle?

1164

---

What is difference between user and database in teradata?

1112

---

Why do you get spool space errors? How do trouble-shoot them?

1088

---

How do you verify a complicated sql?

1111

---