Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question