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
- 9656 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / bharath
Hi,
First convert your column datatype date to string using modify
stage and then by transformer stage change it as
StringToDate(datestring,["yy-dd-mm"])
then u get...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a quality stage in datastage tool?
Which warehouse using in your datawarehouse
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
How to Remove Duplicate using SQL?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is size of a transaction and an array means in a datastage?
Differentiate between operational datastage (ods) and data warehouse?
What are the types of jobs we have in datastage?
What are the functionalities of link collector?
how to export or import the jobs in .ISX file
How many types of hash files are there?
What are the components of ascential data stage?
What are the different types of lookups in datastage?
Can you highlight the main features of ibm infosphere information server?
What is the different type of jobs in datastage?
