Answer Posted / ganesh

If you want dumps you mail me (ganylala@gmail.com)

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

1067

---

What are the types of views in datastage director?

1762

---

Describe routines in datastage? Enlist various types of routines.

1009

---

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

---

How you Implemented SCD Type 1 & Type 2 in your project?

4129

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2628

---

What are some prerequisites for datastage?

1096

---

What are some different alternative commands associated with "dsjob"?

1165

---

What is a folder? Difference types of stages?

1171

---

What are the features of datastage flow designer?

1037

---

what is flow of project?

1999

---

sed,awk,head

1461

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2897

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408

---

options available in sequence job to run,validate?

1314

---