Page 1 of 1
Sparse Lookup
Posted: Tue Feb 12, 2013 3:27 am
by vamsi.4a6
I read Sparse lookup can be used only when the reference link is Database.Just want to know if it can be still used if ref link is sequential file?
Re: Sparse Lookup
Posted: Tue Feb 12, 2013 3:57 am
by dr.murthy
No, Sparse lookup supports for DB stages only
Posted: Tue Feb 12, 2013 4:02 am
by jerome_rajan
And only for DB2 and Oracle, I believe.
Posted: Tue Feb 12, 2013 4:03 am
by vamsi.4a6
Thanks for the input.Could you plese clarify below doubts?
1)I did not find any option in Lookup Stage to select the sparse Lookup property?Could you please help me where to select that property?
2)Why should not we use Sparse lookup for sequetail file stage?
Posted: Tue Feb 12, 2013 4:05 am
by dr.murthy
You cannot see this option in Lookup stage, when you use the DB stage as a reference you can see this option in DB stage properties tab.
Posted: Tue Feb 12, 2013 4:36 am
by jerome_rajan
Sparse Lookup is a concept that's based on moving the processing of a join(lookup) to a database. Essentially, DataStage will send your rows in the stream link one by one to the reference DB and the join will be performed in the DB. Since join is a relational concept and does not apply to non-structured data like flat files, you cannot use a non-DB stage