Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 modeling tool do you use?

6 Answers   HP,


In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  


What is the command line function to import and export the ds jobs?

0 Answers  


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,


5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  


how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,


What is "fatal error/rdbms code 3996" error?

0 Answers  


What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,


Name the command line functions to import and export the DS jobs?

0 Answers  


What are the various kinds of the hash file?

0 Answers  


hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,


Categories