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
Differentiate between Join, Merge and Lookup stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the types of hashed files in data stage
how to implement scd2 in datastage 7.5 with lookup stage
what is use of SDR function?
Why do you need stage variables?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Which algorithm you used for your hashfile?
What is the difference between server job and parallel jobs?
Can you explain kafka connector?
What is datastage engine?
What are the features of datastage flow designer?
How one source columns or rows to be loaded in to two different tables?
What are some prerequisites for datastage?