Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Define Job control?

1125


Differentiate between hash file and sequential file?

1051


in oracle target stage when we use load option and when we use upsert option?

2262


Explain the importance of surrogate key in data warehousing?

1172


what is repositery?

1824


Define Data Stage?

1076


what is the custome stage in datastage? how can we impliment that one? plz tell me

2348


What are the main features of datastage?

1265


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042


whom do you report?

1913


Describe the architecture of datastage?

996


How to read the length of word in unix?

1367


Define ds designer?

1252


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2237


Difference between data warehousing and olap?

1073