Interested to Buy Any Domain ? << Click Here >> for more details...
in source is like seq file in date column have
dd-mm-yy
dddd-mmmm-yyyy
mm-dd-yy
yy-dd-mm
yy-mm-dd
i want to display only yy-dd-mm date formats only in tgt?
- 2 Answers
- 9773 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the process of killing a job in datastage?
What are routines in datastage? Enlist various types of routines.
root tree will find which is server job and which is parallel job?
What is use Array size in datastage
how to add a new records into source?
What is the precedence of stage variables,derivations, and constraints?
What are the types of containers in datastage?
how many rows sorted in sort stage by default in server jobs
What are routines in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to perform incremental load in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is orabulk stage?
Give an idea of system variables.
What is the differentiate between data file and descriptor file?
