Abinitio - what is the lookup function used to retrieve the particular duplictae datarecords in the lookup fil

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 145 of 196

what is the lookup function used to retrieve the particular duplictae datarecords in the lookup file

Total Answers and Comments: 3

Last Update: June 29, 2009 Asked by: swarna

Sponsored Links

Best Rated Answer

—

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

November 13, 2006 14:36:30

sekhu_da

Member Since: November 2006 Contribution: 14

RE: what is the lookup function used to retrieve the ...

Lookup -

looking up the data ...

suppose you have input it consits of emp_id

in lookup file it will be hving all the employes of the company..

u will seach ur input file aganist the lookup file so that the files your processing is ryt employes or not ..

most of the time input files comes from different loc..

in simple terms its like cross check

Is this answer useful? Yes | No

November 16, 2006 12:38:34

pradeep

RE: what is the lookup function used to retrieve the ...

lookup_next function is used for retrieving duplicates records of that particular record

Is this answer useful? Yes | No

June 29, 2009 09:30:52

abhi_fresh_as_dew

Member Since: September 2008 Contribution: 12

RE: what is the lookup function used to retrieve the particular duplictae datarecords in the lookup file

Use lookup_count for finding the duplicates and lookup_next for retrieving it.

If lookup_count (string file_label [ expression [ expression ... ] ] )>0

lookup_next ( lookup_identifier_type lookup_id string lookup_template )

Njoi!!
Abhi - fresh as dew!

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank