Abinitio - Abinitio Lookup

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 176 of 196

Abinitio Lookup

Can we process 1 GB data(1 million records) by using Lookup? How

Total Answers and Comments: 3

Last Update: August 25, 2009 Asked by: shylender

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 10, 2008 06:13:57

rcoon7

Member Since: March 2008 Contribution: 8

RE: Abinitio Lookup

it all depends on the enviornment are running and the memory allocated and the number of concurrent processes running.

It is though not advisible to do the same as this would be definetly a performance hit under normal condition.

Is this answer useful? Yes | No

April 15, 2008 11:08:57

sixto.dsilva

Member Since: March 2008 Contribution: 59

RE: Abinitio Lookup

I think it is not adviseable to use a 1GB lookup file it will definitely effect the parallel processing of other applications and affect the performance.

I would prefer to use the MFS lookup file and not serial lookup file in this case.

Is this answer useful? Yes | No

August 25, 2009 09:04:40

anujaja

Member Since: July 2007 Contribution: 6

RE: Abinitio Lookup

I will suggest you to use Join instead of Lookup for such voluminous data

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank