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
- 8731 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
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the some differences between 7.x and 8.x version of datastage?
How one source columns or rows to be loaded in to two different tables?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
If you want to use the same piece of code in different jobs, how will you achieve it?
On which Dimension Table you implemented SCD Type in your Project
Can you implement SCD2 using join, transformer and funnel stage?
Name the different sorting methods in datastage.
root tree will find which is server job and which is parallel job?
Can we use target hash file as a lookup ?
How a routine is called in datastage job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are stage variables and constants?
What is oci?
Can you explain kafka connector?
