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
Define Job control?
Differentiate between hash file and sequential file?
in oracle target stage when we use load option and when we use upsert option?
Explain the importance of surrogate key in data warehousing?
what is repositery?
Define Data Stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the main features of datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
whom do you report?
Describe the architecture of datastage?
How to read the length of word in unix?
Define ds designer?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between data warehousing and olap?