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
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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Which warehouse using in your datawarehouse
What is difference between join, merge and lookup stage?
What are the job parameters?
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
What is the precedence of stage variables,derivations, and constraints?
How can we improve the performance in datastage?
What are the stages in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How do you register plug-ins?
What are routines in datastage? Enlist various types of routines.
How one source columns or rows to be loaded in to two different tables?
how to delete one row in target dataset