ALLInterview.com :: Home Page kalaajkal.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Data-Warehouse
 
  Teradata (14)  Business-Objects (334)  Cognos (339)  Informatica (498)  Crystal-Enterprise-Suite (22)
  Actuate (18)  Ab-Initio (48)  Data-Stage (49)  SAS (256)  Micro-Strategy (5)
  ETL (132)  Data-Warehouse-General (141)
 


 

Back to Questions Page
 
Question
what is sparse lookup?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
use sparse lookup when reference database is huge i.e ratio 
of input data and reference data is 1:100 or more
 
0
Ramya
 
 
Answer
If reference data is huge then we will go for join stage. 
Then when we will use join and sparce is useful?
 
0
Vin
 
 
Question
what is the diff between sequential file and fileset stages?

Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
File set can be stored on multiple Unix files as flat files.
 file set contains discriptor file and individual raw data 
files . No. of raw data files depends on configuration file.

There will be some limit like 2G limit on some file 
systems . we can distribute data over nodes to prevent 
overrun.
In such cases file set will be useful than sequential file.
 
0
Aparna Kanduri
 
 
 
Question
Why we need datasets ratherthan sequential files?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
First we Know about Seq file and Dataset.

Seg file is used Extract the from flatfiles and load into 
flatfiles and limit is 2GB

Dataset is a intermidiate stage and it has paralism when 
load data into dataset and it inprove the performanece.
 
0
Kiran
 
 
Question
what is combinability and non combinability?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
combinality is a mode in Advance tab of a stage.

The mode can have values: Auto, Combinable, Don't Combine. 
Auto: let the DataStage decide whether to combine the 
stages 
Combinable: Combine the operator with other stage if 
possible 
Don't Combine: do not combine them at all 

I think Don't Combine may be non combinability in your 
terms.
 
0
Ramya
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com