Answer Posted / datastage4you

Now, for auditing Datastage jobs, you can use Operation Console database ODB to fetch the same details easy way

Thanks
www.datagenx.net

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?

2167

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1047

---

Differentiate between data file and descriptor file?

1032

---

whom do you report?

1913

---

what are the errors,warnings in datastage

2678

---

Differentiate between validated and Compiled in the Datastage?

1255

---

Describe link sort?

994

---

Nls stands for what in datastage?

1181

---

Is the value of staging variable stored temporarily or permanently?

983

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

911

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1487

---

What are the components of ascential data stage?

1167

---

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

2089

---

How to reverse the string using unix?

3486

---

How to convert RGB Value to Hexadecimal values in datastage?

3981

---