DSXchange

Ray, thanks for your time and could you be more specific on the where clause?? I just want to write some transformation logic in the transformer so that all the fileds can show the curent timestamp and old timestamp needs to remove...

Thanks

Hello, Please let me know how to remove the record which is having the old timestamp value. For eg: ETLTimestamp column is set as DSJobstartTimeStamp in transformer. In the target, when i view the data its showing previous dates in few columns and rest all showing the correct timestamp value. But, I...

alright ray..will do it...thanks

My design of the job is


Row Generator----XML Input----Transformer----Dataset

I have also tried with Seq file as Source....

Hi Everybody I am reading an XML file from Sequential file stage. with help of only one sing key column with Varchar 255 After that i am processing that XML file with help of XMLInput Stage. In the XMLInput stage what i did is. In Stage tab: Transformation Settings: A) I enable Repetition element re...

Hi,

I am using Seq Stage to read xm..design like

seq--xml input--DRS

Hi Everyone, Am getting the following fatal when i read the XML from the Sequential File as it contains lots of records. The error is: 1) Error reading on import. 2) Consumed more than 100,000 bytes looking for record delimiter; aborting. Could you please let me know the format option of the Sequent...

Ok somehow i am unable to open that link..will check that later...i tried sequential also...but still cannot see the records in PX..let me know the seq stage properties like format etc for the XML files...so that i can try that also..thanks balaji

server will work fine and dont think so px will execute on windows platform..it needs unix to support...chek it....

Thats ok Balaji, but i cannot open that link and any other way?

Yeah Kumar is right and the code is also correct. create a stage variable for date and then give the derivations.

Hi, Please let me know what option did u choose while installing Oracel 9i..there is atleast 6 options to choose like eg: Oracle for Datawarehouse or something like that...Please choose the option Oracle tor Datawarehouse when u install next time if only u using the Database for Datawarehouse. Why a...

Hi Balaji,

Please see my above questions and let me know does it make sense. and the XML input we r using because we are generating the XML files.. and row gen--dataset is not a correct design according to this.

Yeah the peek is checking as the expected data from row gen..but again my question is If am using Folder stage--XML Input--Sequential file in Server job, am getting the exact output and correct records. According to business rules in PX the design should be Row Gen--XML Input--DRS stage (at present ...

No Kumar, thats not working and the same result as not getting records in the target? any other suggestions?