JDBC TO SFTP Scenario

[vijender_p]

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

[Former Member · Accepted solution]

Hi Vijendra,

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

Regards,

Sachi

[Former Member]

Hi Vijender,

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

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

[sendhil_kumar]

Hi Vijender,

Try this.

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

--

Sendhil

[iaki_vila]

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.

[vijender_p]

hi ,

If at all we go on with the  cc BPM's it will be to complicated right and As of my knowledge can we do it my JAVA mapping ???

[Former Member]

Dear Vijender,

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

Regards,

[naveen_chichili]

Hi,

Could you please elaborate your requirement.

Regards,

Naveen