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



in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-..

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

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-..

Answer / 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

More Data Stage Interview Questions

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


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)

3 Answers   HSBC,


Could anyone give brief explanation bout datastage admin

0 Answers  


Explain ibm infosphere information server and highlight its main features?

0 Answers  


Explain how a source file is populated?

0 Answers  






What is the purpose of pivot stage and types of containers in datastage

0 Answers  


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


what is ds administrator used for?

0 Answers  


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?

2 Answers   TCS,


How complex jobs are implemented in datstage to improve performance?

0 Answers  


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


Categories