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 |
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
Could anyone give brief explanation bout datastage admin
Explain ibm infosphere information server and highlight its main features?
Explain how a source file is populated?
What is the purpose of pivot stage and types of containers in datastage
1)How to Duplicate Records Delete in Sequential file?
what is ds administrator used for?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
How complex jobs are implemented in datstage to improve performance?
how can we create rank using datastage?what is the meaning of rank?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?