Loading transaction data from flat file to DSO

Posted by on





1.  Create  flat file



save as csv file


2. Create DataSource
























Now dataSource is ready..

3. Create InfoPackage














4. Create DSO (target)























5. Create Transformation












activate transformation



6. Create DTP
















now data is available in DSO...










This is how new data table will appear..













we dont have any data in active table .. because our data is not activated...

lets activate our request...
















wait till the job is finished...

now come back and check the active data table and new data table..



we can get this data in active data table....

and there will be no records in new data table...




Comments

  1. AnonymousFebruary 23, 2014 at 9:26 AM

    Thank you sir. Very helpful to understand the concept and follow the screens. Thanks.

    ReplyDelete
  2. AnonymousMay 14, 2014 at 1:02 PM

    Slms Aslam, well explained and steps and process. Thanks a lot.

    ReplyDelete
  3. UnknownOctober 19, 2014 at 6:50 AM

    it was fine but i have a doubt we all know employee customer vendor doc no id comes under chars so they belong to master data.....without uploading them to master data how can we upload data as transaction data bcoz transaction data needs to take reference from master data .....so can u plz explain me this step.......

    ReplyDelete
  4. UnknownNovember 18, 2019 at 6:18 AM

    Nice explanation & easily understandable
    Great job
    Thank you

    ReplyDelete

Post a Comment