Skip to Content
author's profile photo Former Member
Former Member

SQL DATA load to PSA

Hi all

I'm Extracting data from SQL source I Have a filed " REASON " Datatype:Varchar ,length:100" is mapped to " Zreason, char: length50" after loading into PSA corresponding records from source are coming blank for this field. its extracting all the records but values are blank. Ex: 1347 records available for Reason field, but in PSA only 27 records are availbale for Reasoninfo object and rest of the records blank or 0,00 , any suggestions..

Thanks In Advance for all of your time.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 07, 2012 at 12:05 PM

    Hi,

    Please check whether the following explanation helps you:

    "

    In the data acquisition process from source system your need to create a DataSource to join the source system with BI system. You create your extractor in your ECC and after that you replicate this in your BI system, then you create a InfoPackage to upload data from source system to BI system, some thing you usually set up some filter in you InfoPackage, I think there son filter in the tab Data Selection in the InfoPackage, try to check your InfoPackage configuration.

    "

    Please award points if helpful.

    Thanks & Regards,

    Sapna

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member T Ravi Chandra

      Hi RaviChandra / All

      I'm extracting 25 fields from SQL view, one field " Reason" has values like1) Offer can't be made 2)BGC issue 3) Not intrested like this there are 20 reasons coming in r"REASON" fileld from SQl view. I have checked 1)data type ,length, lower case check in data source,External lenght in data source, replicated data source and ran package again, but not able to fix this, Plz suggest me how to handle this issue.

      Thanks

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.