Skip to Content

JDBC TO SFTP Scenario

Hi All ,

My scenario is JDBC to SFTP scenario.

We took data from database and splitted into 6 files.

But there is duplication in our files. For example 10 lines come to file with the same ProductName.

How can I reduce the 10 lines to 1 line?

How can I avoid duplication with  mapping?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2015 at 09:58 AM

    Hi Vijendra,

    Please use remove context--> Splitbyvalue(ValueChange).

    Regards,

    Sachi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:12 AM

    Hi Vijender,

    Try this.

    Field -> Remove Context -> Sort -> SplitbyValue(Value Change) -> Collapse Context -> Target

    --

    Sendhil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 10:21 AM

    Hi Vijender,

    Please go through below link, this will be very helpful.

    http://wiki.scn.sap.com/wiki/display/XI/Explain+node+functions

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 06:01 AM

    Hi,

    Could you please elaborate your requirement.

    Regards,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 06:10 AM

    Dear Vijender,

    I am not sure with the requirement but you can use the collapse context for removing duplicates.


    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:08 AM

    Hi Vijender,

    If the duplication issue is the same message you can avoid it like Rudra said. If the duplication issues comes for example in the first jdbc poll and the third one, it's more complicated and you will have two options to do it:

    1. Do ccBPM to have the the polls needed to create the six files and to control the duplication issue.

    2. To have an external or ABAP table to store the ProductNames read and to avoid with a JDBC/RFC lookup the duplicates.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded