Answer / bharath

Hi,
First convert your column datatype date to string using modify
stage and then by transformer stage change it as
StringToDate(datestring,["yy-dd-mm"])
then u get...

Answer / ram

hi,

before importing the metadata into the sequential file
convert the column datatype date to string, then use
transformer stage change it as stringtodate.

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

What are the important features of datastage?

0 Answers  

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

How many types of views are there in a datastage director?

0 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

What are routines in datastage?

0 Answers  

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

Where do the datastage jobs get stored?

0 Answers  

---