Interested to Buy Any Domain ? << Click Here >> for more details...
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 a merge?
Difference between data warehousing and olap?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is staging variable?
What steps should be taken to improve Datastage jobs?
What are some prerequisites for datastage?
What are the primary usages of datastage tool?
Differentiate between odbc and drs stage?
Could anyone give brief explanation bout datastage admin
how to export or import the jobs in .ISX file
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the flow of loading data into fact & dimensional tables?
What a datastage macro?
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?
