Answer Posted / prasad

use column datatype as varchar

DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')

use above format in derivation for transformer stage, u will get the desired output.

project Steps,hits, Project level HArd things,Solved methods?

2183

---

What all the types of jobs you developed?

1248

---

how to write server Routine coding?

2181

---

Where do the datastage jobs get stored?

1268

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1096

---

Explain usage analysis in datastage?

1224

---

What are datastage sequences?

1169

---

What are the types of hashed files in data stage

1146

---

What are the different plug-ins stages used in your projects?

1125

---

Define Job control?

1226

---

Demonstrate experience in maintaining quality process standards?

2638

---

CHANGE CAPTURE

1353

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3181

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2285

---

How do you remove duplicate values in datastage?

1197

---