Answer Posted / sadanand

HI All,

I would like to add one more point to JOIN.
To achieve full outer join the number of inputs need would
be only two.
The Primay table need to be sorted.
Memory used is very less compared to Lookup.

Regards,
Sadanand.

What is a folder? Difference types of stages?

1241

---

How and where you used hash file?

1223

---

how can we create rank using datastage?what is the meaning of rank?

8856

---

How the ipc stage work?

1170

---

what is the difference between == and eq in UNIX shell scripting?

1558

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2225

---

What is ibm datastage?

1023

---

Explain the importance of surrogate key in data warehousing?

1233

---

What are the repository tables in datastage?

1351

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1467

---

Why fact table is in normal form?

1309

---

What is the difference between informatica and datastage?

1303

---

How many areas for files does datastage have?

1218

---

How can we improve performance of data stage jobs?

1068

---

Define Data Stage?

1143

---