Answer / 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.

Answer / p.n.chowdary

I think this is not posible......
But we can load date in sequenatial file stage.

Answer / sneha

Hi ,

In seq stage , in format tab , there is option where we can define format for date . Then we can read date data with date datatype .

correct me , if I am wrong

Answer / saidarao

by using transformer stage
in functions one option like-string 2 date ,we can possible.

Answer / ramesh

Datastage contains so many inbuilt functions...
simply we use this type conversion like this
StringToDate(file1.Date1,"%mm/%dd/%yyyy");

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Define repository tables in datastage?

0 Answers  

---

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

---

What are stage variables and constants?

0 Answers  

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  

---