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
- 22863 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 |
I have a few records just I want to store data in to targets cycling way how?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
What are the functionalities of link collector?
What is quality stage?
what is use of SDR function?
how to delete one row in target dataset
how to do pergformence tuning in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Teradata 
