How to Convert a string function to date function by using
only sequential file stage with out using other stages ?
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 |
what is use of SDR function?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
On which Dimension Table you implemented SCD Type in your Project
can explain wt is the pool for file.
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the flow of loading data into fact & dimensional tables?
what is ds administrator used for?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
Please tell me What is difference between 8.0 and 8.1
Explain ibm infosphere information server and highlight its main features?
How do you import and export the datastage jobs?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000