Answer Posted / shubhangi

A star schema has one Fact tables and many dimensional
tables to store the related.

FSLDM (Financial services logical data model) is a model
proposed and designed by NCR to cater the needs of financial
sectors, specially the Banking domain.

It has many Fact tabls and dimension tbls.

The major fact tbls include Party (Customers of the bank),
Product (Services offered by the bank), Event (An event
occurred ex: An ATM transaction), Agreement (A deal betweem
the party and the bank for a product)etc...

The FSLDM can be customized to cater to bank's specific needs.

What is meant by a Parsing Engine?

1237

---

What is a level of granularity of a fact table?

1219

---

Explain the parallel data extension in teradata?

1152

---

What happens when a node suffers a downfall?

1190

---

What is upsert statement in teradata?

1194

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1028

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1257

---

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

1094

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2470

---

What are the different design perspectives used in teradata?

1035

---

Explain fastload in teradata?

1147

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1084

---

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

1128

---

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

1155

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3422

---