how do u convert date in 20-12-07 to dec-20-2007 or 20-dec-
2007 or 20-dec-07 in parallel
Answer Posted / prasad
use column datatype as varchar
DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')
use above format in derivation for transformer stage, u will get the desired output.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hashfile and sequential file?
Where do the datastage jobs get stored?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how can we create rank using datastage?what is the meaning of rank?
What is the different type of jobs in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
Is possible to create skid in dim,fact tables?
Different ways a project can be moved to production ?...example ….export-import and Version control.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Where do you see different stages in the designer?
Describe the main features of datastage?
Define meta stage?
Name the command line functions to import and export the DS jobs?
What are the difference types of stages?
Which warehouse using in your datawarehouse