hi, before importing the metadata into the sequential file convert the

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?

Question Posted / ram

2 Answers
9658 Views
Wipro, I also Faced
E-Mail Answers

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

Define meta stage?

1205

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

what are the devoleper roles in real time? plz tell i am new to datastage....

2164

How can one find bugs in job sequence?

1414

What is the difference between informatica and datastage?

1229

How you Implemented SCD Type 1 & Type 2 in your project?

4129

How to convert RGB Value to Hexadecimal values in datastage?

3998

What is staging variable?

1096

How do you remove duplicate values in datastage?

1151

What is difference between symmetric multiprocessing and massive parallel processing?

1144

how to sort two columns in single job in datastage.

2905

options available in sequence job to run,validate?

1320

How to manage date conversion in Datastage?

1138

Triggers,VIEW,Procedures

1221