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

How complex jobs are implemented in datstage to improve performance?

600


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

4569


Explain datastage architecture?

820


What is the roundrobin collector?

641


What are the main differences you have observed between 7.x and 8.x version of datastage?

624






How do y read Sequential file from job control?

14418


How can you write parallel routines in datastage PX?

620


Enlist various types of routines in datastage.

645


How many types of hash files are there?

612


What are sequencers?

616


How do you import and export data into datastage?

703


Differentiate between odbc and drs stage?

593


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1656


What is difference between symmetric multiprocessing and massive parallel processing?

655


What is the purpose of pivot stage?

608