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 do you mean by tpt in teradata?

1022

---

How can you track login parameters of users in teradata?

1198

---

What is the function of parser component in teradata?

1092

---

what is object level locking ? where do appear this type of locking ?

3504

---

Explain vproc in teradata?

1011

---

During the Display time, how is the sequence generated by Teradata?

1064

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

1012

---

Which is more efficient group by or distinct to find duplicates?

1093

---

How many codd's rules are satisfied by teradata database?

1116

---

How to select first n records in teradata?

1111

---

Define views in teradata with general syntax.

1038

---

Which is faster fastload or multiload?

1122

---

Explain the advantages of partitioned primary index in a query?

1028

---

How do you define Teradata?

1041

---

How many tables can you join in v2r5?

1075

---