Skip to Content
avatar image
Former Member

Joining two flat files

Hi Gurus,

I'm a newbie to SAP BODS. We have a scenario, where we are joining two flat files to get single column. Both Primary and Reference file records were suppose to be in millions. We don't have any staging DB to push down to sql operations.

In this case, is it better to go for JOIN or LOOK UP?  Is there is any other way to improve performance other than staging DB?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 22, 2015 at 03:16 PM

    No, the only viable option is a staging database.

    Why do you say you son't have any? Where are your DS repositories created? Use the same database environment, seperate schema or database, depending on the type.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2015 at 03:25 PM

    Since you do not have the staging DB , look up option is ruled out. You can join the two flat files ( as file formats).I assume you produce a output file as a result.Look for "Join ranks" in this article Joining tables in the engine - Enterprise Information Management - SCN Wiki

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2015 at 05:43 PM

    So, you are preferring JOIN over LOOK UP for large flat files with records in millions? Kindly let me know.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded