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 |
What modeling tool do you use?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
What is the command line function to import and export the ds jobs?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
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
how many dimentions and fact tables used in your project and what are names of it?
What is "fatal error/rdbms code 3996" error?
What is the function in Transformer stage can act as Rank Function in oracle
Name the command line functions to import and export the DS jobs?
What are the various kinds of the hash file?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer