Interested to Buy Any Domain ? << Click Here >> for more details...
How to Convert a string function to date function by using
only sequential file stage with out using other stages ?
- 5 Answers
- 22460 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 |
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
If you want to use the same piece of code in different jobs, how will you achieve it?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
how to unlock a locked job in datastage 8.0
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
Name the command line functions to import and export the DS jobs?
what is operator combinality in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is a nodemap constraint
Teradata 
