GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 106 of 119    Print  
Sparse Lookup and Normal Lookup
What are the differences between Sparse Lookup and Normal Lookup?


  
Total Answers and Comments: 2 Last Update: June 23, 2008     Asked by: venkata ramana 
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 11, 2008 05:40:42   #1  
nagoosk Member Since: November 2007   Contribution: 14    

RE: Sparse Lookup and Normal Lookup
Normal Lookup:In this when ever ds wants to look up it just place the target table data into buffer.

Sparse Lookup:To look up itr fires an sql query to the database instead of placing into buffer.To use sparse look up your target database must be larger than source table and your target should be a database of any type.

 
Is this answer useful? Yes | No
June 23, 2008 05:24:29   #2  
nagakalyan Member Since: June 2008   Contribution: 0    

RE: Sparse Lookup and Normal Lookup
sparse means we will generate query source  bases and one by one record  ,and normal is we can take look up on target table at a time multiple records
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : lookup we can set condition option otherwise then reject records enter into target we can direct load data what ever it may be load and create ...
Read Answers (1) | Asked by : Ninganagouda

Latest Answer : Lookup stage: 1.Can only return multiple matching rows from one reference.2. Can reject rows based on constraint.3. Can set failure.4. Does not need partitioned and sorted input. Merge stage: 1. Can reject rows if fail to find match.2. Does need partitioned ...
Read Answers (2) | Asked by : vijay

what is multiple instances?how u trigger the job in windows?how can u see,delete dataset in unix and windows?what is the function of shared container?why don't we use odd nodes to run the job?what 
View Question | Asked by : Nagoor

How to implement in datastgae like the job should abort after it loads 10 records into the target using lookup? 
Latest Answer : you can abort a job after n records which is available while you r running the job you can see tha option as "abort job after _____" . there you can specify the number ...
Read Answers (1) | Asked by : vivo7000

when do one use dataset stage/lookup file stage/file stage in a parallel job?or in other way what is the significance of these files...wat are their differences? 
Latest Answer : DataSetFile: DataStage PX jobs uses the dataset file to organize the data.Dataset files preserves partitioning means u need not to partition the data when ever u read the data.It maintaines the persistent form.These are the operating system files.we can't ...

What are the differences between Sparse Lookup and Normal Lookup? 
Latest Answer : sparse means we will generate query source  bases and one by one record  ,and normal is we can take look up on target table at a time multiple records ...

What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer? 
View Question | Asked by : Suri123


 Sponsored Links



 
Related Articles

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape