How to Convert a string function to date function by using
only sequential file stage with out using other stages ?
- 5 Answers
- 21498 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkatesh
1) Open the Sequential file stage properties.
2) Go to Format > Type Default > Date > Format String.
3) Type the format of the string in which the source date is
coming. For ex. For 20101201 - Type %yyyy%mm%dd.
4) Go to Column tab, Chose SQl Type as Date.
Now, try to view data. YOu should be able to see date as
2010-12-01.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / p.n.chowdary
I think this is not posible......
But we can load date in sequenatial file stage.
| Is This Answer Correct ? | 19 Yes | 6 No |
Answer / sneha
Hi ,
In seq stage , in format tab , there is option where we can define format for date . Then we can read date data with date datatype .
correct me , if I am wrong
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / saidarao
by using transformer stage
in functions one option like-string 2 date ,we can possible.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / ramesh
Datastage contains so many inbuilt functions...
simply we use this type conversion like this
StringToDate(file1.Date1,"%mm/%dd/%yyyy");
| Is This Answer Correct ? | 0 Yes | 5 No |
Can you explain tagbatch restructure operator?
What is exact difference between Parallel Jobs and server Jobs..
What are stage variables, derivations and constants?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Nls stands for what in datastage?
how to write server Routine coding?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Teradata 
