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 are the main differences you have observed between 7.x and 8.x version of datastage?
Define data aggregation?
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 datastage and informatica?
Describe link sort?
How many types of views are there in a datastage director?
What is a quality stage in datastage tool?
How a source file is populated?
How many types of stage?
What are orabulk and bcp stages?
How many types of hash files are there?
How can one find bugs in job sequence?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the processing stages?
in oracle target stage when we use load option and when we use upsert option?