Highlight the need for Performance Tuning.

0 Answers  

---

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,

---

What are the newly developed features of Teradata?

0 Answers  

---

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 are the uses of bynets in multi-node systems?

0 Answers  

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---

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

0 Answers  

---

what is identity column in TD?

2 Answers   Wipro,

---

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

4 Answers   IBM,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---