Answer Posted / mcssrinivas009

using random partiopn

How to Remove Duplicate using SQL?

1369

---

What are the different type of jobs in datastage?

1043

---

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?

2179

---

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

2505

---

Is possible to create skid in dim,fact tables?

2636

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

---

What are the differences between datastage and informatica?

1177

---

how to write server Routine coding?

2126

---

Why we use surrogate key?

1235

---

What is the process of killing a job in datastage?

1020

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2106

---

What is orabulk stage?

1047

---

what is use of SDR function?

5173

---

What steps should be taken to improve Datastage jobs?

1073

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

---