 Related Questions In datastage how we can do for this type or requirement:The sales data will be extracted in 2 flat files.Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif suppose we run first time means the job names are Read Answers (1) | Asked by : sreedhar k Error while connecting to DataStage project-expiry date '-479/1/71379' is unrecognizable Requirement: I have installed datastage7.5 server/client on windows 2003 server, the installation has been done successfully, but later when I login into the projects it is giving an error.Requirement : I have installed on the Windows 2003 server datastage7.5 server/client. the installation has been done successfully. but later when I Login into the projects it is giving an error. Error Description: Read Answers (1) | Asked by : Prashanth Reddy Tags : Windows 2003 Hi,I have a .csv file as my source.I am reading the data using asequential file stage.Then I am validating the format of the data using a schema file.The date format of the incoming file is '%dd/%mm/%yyyy'.So Latest Answer : Read the date field column as varchar and use transformer to check nullabiltiy and if null found assign some default value say '12-Dec-9999' and use the appropriate conversion function and process.At the time of loading, check the date ... How to implement the scenario: Add 10 days to a particular date in Datastage PX Latest Answer : extract the day part of the date by using the string function and then add how many days u want and then again add all those parts into single string and then convert the string into date object. ... How to clear logs after 5 days, by using a routine?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
