Sparse Lookup
Moderators: chulett, rschirm, roy
Sparse Lookup
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?
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
And only for DB2 and Oracle, I believe.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
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
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.