Answer Posted / raji

1.Avoid using transformer stage for renaming some
columns.Because it will slow down the performance of the
jobs.. Try to use Copy stage for renaming the columns.
2.Take only the required columns during the table level
lookups. Remove all the unnessary columns
3.By using partioning technique. It depends on our
requirement. It will increase the performance as well

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?

2174

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2501

---

Can you explain link buffering?

1175

---

What are sequencers?

1107

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1210

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1267

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2221

---

What is the difference between odbc and drs stage?

1087

---

Does datastage support slowly changing dimensions ?

1103

---

What are system variables and sequencers in datastage

1115

---

What is oci?

1298

---

CHANGE CAPTURE

1298

---

Differentiate between validated and Compiled in the Datastage?

1270

---

How do you import and export data into datastage?

1229

---

How do you run datastage job from the command line?

1081

---