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?
Answers were Sorted based on User's Feedback
Answer / bharath
Hi,
First convert your column datatype date to string using modify
stage and then by transformer stage change it as
StringToDate(datestring,["yy-dd-mm"])
then u get...
Is This Answer Correct ? | 3 Yes | 1 No |
how many types of sorting the data in data stage?
what is use of SDR function?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
when will you go for dataset and fileset?
can we half project in parallel jobs and half project in server jobs?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is a quality stage in datastage tool?
Describe the architecture of datastage?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?