Answer Posted / sundar

Hi , Im planning to take teradata certification exams. Can you please send me the dumps at my mail sundar.nani.svec@gmail.com. Thanks.

How is the teradata different from oracle?

1166

---

Highlight all the modes that are present under Confidence Level.

1011

---

How can bottlenecks be identified?

1061

---

What is a dimension table?

1102

---

Explain fastload in teradata?

1147

---

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

1131

---

Describe the between keyword in teradata?

1084

---

Explain vproc in teradata?

1047

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2530

---

What is smp and mpp platforms?

1035

---

What are the different methods ot loading a dimension table? A fact table etc?

1084

---

What are the commands to make a new table, change a table and remove a table in teradata?

1184

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1038

---

What tools would you use for that?

1154

---

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

1128

---