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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Define Merge?
wt is the diff b/w odbc and oracle stage
can any one tell me how to install datastage 8.1 in windows xp with wizard
Describe stream connector?
what is combinability and non combinability?
Name the different types of Lookups in Datastage?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
how can find maximum salary by using Remove duplicate stage?
How do u set a default value to a column if the column value is NULL?
Why do you need stage variables?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10