Answer Posted / swetha

use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only

On which interface you will be working as a developer?

985

---

Name the command line functions to import and export the DS jobs?

1089

---

What are some prerequisites for datastage?

1040

---

what is the use of materialized view?

1485

---

What are the benefits of datastage?

1171

---

Terminate Activity

1230

---

What is datastage engine?

1118

---

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?

2129

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2314

---

Can you explain link buffering?

1104

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

950

---

Explain entity, attribute and relationship in datastage?

1042

---

CHANGE CAPTURE

1256

---

What is the difference between an operational datastage and a data warehouse?

1087

---

How many types of hash files are there?

1116

---