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 string manipulation operators and functions associated with teradata?

1045

---

What is multi insert?

1013

---

What is a clique?

1040

---

Different phases of multiload?

954

---

What does sleep function does in fast load?

1091

---

Define views in teradata with general syntax.

1004

---

Describe the set operators in teradata.

973

---

How to find duplicates in a table?

1168

---

What is the difference between teradata and basic rdbms?

971

---

What are the advantages of teradata?

970

---

How will you solve the problem that occurs during update?

1017

---

In BTEQ, how are the session-mode parameters being set?

1109

---

What is meant by a Highest Cost Plan?

1012

---

Explain the types of join supports by teradata?

951

---

What are the scenarios in which full table scans occurs?

968

---