Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Load Data Without Using Lookup

Load Data Without Using Lookup 8 years 6 months ago #4367

  • Brendan
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
Hi

I have the following situation.
I have two sources. One is flat file and another one is lookup table in the database.
In flat file I have 20 million records and lookup table contain 6k records.
If I use lookup to load data then it takes very log time.
Is there any alter way to load the data with out using lookup?

Thank you,
Brendan

Please Log in or Create an account to join the conversation.

Re: Load Data Without Using Lookup 8 years 6 months ago #4368

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7839
  • Karma: 33
  • Thank you received: 472
I doubt that you will be able to speed it up.
6k is not a lot of records for a lookup
Even if you use "SQL after" to update your table to will take a while to do it in the database
20mil records a is a lot of records.

Mike
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 182 guests and one member online