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...

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?

Answer Posted / ram

hi,

before importing the metadata into the sequential file
convert the column datatype date to string, then use
transformer stage change it as stringtodate.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2102


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5043


Which warehouse using in your datawarehouse

2115


What is difference between join, merge and lookup stage?

1035


What are the job parameters?

1156


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2166


What is the precedence of stage variables,derivations, and constraints?

1026


How can we improve the performance in datastage?

1059


What are the stages in datastage?

1026


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1134


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2127


How do you register plug-ins?

920


What are routines in datastage? Enlist various types of routines.

1047


How one source columns or rows to be loaded in to two different tables?

1070


how to delete one row in target dataset

3061