Answer Posted / vivek nigam
If the datatype of the input is date then you need to
convert it to Char and the you can formulate it to Date
with the new format.
to_date(to_char(<Input Field>,'dd-m-yyyy'))
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is process model?
what are the errors,warnings in datastage
What are the various kinds of containers available in datastage?
I have a few records just I want to store data in to targets cycling way how?
On which interface you will be working as a developer?
how do u catch bad rows from OCI stage? And what CLI stands for?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between server job and parallel jobs?
What are the functionalities of link partitioner?
What are the types of jobs we have in datastage?
Define Routines and their types?
Name the different types of Lookups in Datastage?
Can you explain players in datastage?
Where do you see different stages in the designer?