Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / simha

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 the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

what is set mapping in datastage??

2 Answers   ADP,

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

For more Data Stage Interview Questions Click Here
Categories