How to Convert a string function to date function by using
only sequential file stage with out using other stages ?
Answer Posted / 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 |
Post New Answer View All Answers
what is repositery?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the partitioning techniques available in link partitioner?
On which Dimension Table you implemented SCD Type in your Project
Is the value of staging variable stored temporarily or permanently?
What is difference between server jobs & parallel jobs?
What are the steps required to kill the job 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?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
On which interface you will be working as a developer?
whom do you report?
How do you generate sequence number in datastage?
What are the functionalities of link collector?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many areas for files does datastage have?