How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

---

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

0 Answers  

---

How to run the Teradata jobs in unix environment ???

4 Answers   IBM,

---

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

---

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,

---

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

---

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

---

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---