Answer Posted / venkatesh

1) Open the Sequential file stage properties.
2) Go to Format > Type Default > Date > Format String.
3) Type the format of the string in which the source date is
coming. For ex. For 20101201 - Type %yyyy%mm%dd.
4) Go to Column tab, Chose SQl Type as Date.
Now, try to view data. YOu should be able to see date as
2010-12-01.

What all are the different way to run a job?

1095

---

Name the third party tools that can be used in datastage?

1076

---

How to convert RGB Value to Hexadecimal values in datastage?

3998

---

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?

2234

---

Define Data Stage?

1096

---

What is a merge in datastage?

1271

---

How rejected rows are managed in datastage?

1522

---

What is the roundrobin collector?

1099

---

Describe the architecture of datastage?

1010

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

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

---

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

2110

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1382

---

Explain the importance of surrogate key in data warehousing?

1191

---

How you can fix the truncated data error in datastage?

1793

---