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 |
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
Can we use target hash file as a lookup ?
What is the process of killing a job in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
can we half project in parallel jobs and half project in server jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is sparse lookup?