Answer Posted / chakravarthy kanishka

Look doesnt requires common key coloumn, then why we need key,
if we go for sequential file as a look up, and squential file have huge data,then it hits the performance,again you need to apply the performance techniques to the sequential file while reading the data,so better to avoid sequential file as a reference to look up.

its my guess...
please let me know if wrong.

thanks
kanishka

Define orabulk and bcp stages?

1170

---

What is a merge?

1234

---

Name the different types of Lookups in Datastage?

1311

---

Define ds designer?

1324

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1428

---

How to clean the datastage repository?

1176

---

Is possible to create skid in dim,fact tables?

2689

---

What are the components of datastage?

1177

---

project Steps,hits, Project level HArd things,Solved methods?

2180

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1596

---

Can you explain players in datastage?

1245

---

What is the method of removing duplicates, without the remove duplicate stage?

1073

---

CHANGE CAPTURE

1351

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2851

---

Define Job control?

1220

---