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  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
if we r using aggregator we enabled sorted input but the 
records r not sorted what happen?
 Question Submitted By :: Srinivasarao
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Answer
# 1		 
This technique is used when you want a performnce boost. 
There will be an aggrigator cache created and will be 
indexed. Although you have not given a sorted input it will 
still work fine as it is indexed in cache. Please note this 
is not like a page fault where you have to bring the page 
from the secondary memory when not found in primary memory.
 
Is This Answer Correct ?    0 Yes 2 No
Vaibhav Bhandeo
 
  Re: if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Answer
# 2		 
The session fails.
 
Is This Answer Correct ?    6 Yes 1 No
Purnima
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
How the Informatica Server reads perameter file?  1
how can u load the data in time dimension?  2
how to we create datamart? HSBC1
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions. Wipro1
what is the gap analysis?  1
What is a command that used to run a batch?  2
Whatis the difference between View and Materialized View ? Satyam5
What is up date strategy and what are the options for update strategy?  2
What are the challenges of Dataware housing in the future? HP1
why we use source qualifier transformation? Accenture4
What are the different threads in DTM process?  1
What is aggregate cache in aggregator transforamtion?  2
What is the difference between view and materialised view?  4
What are the data movement modes in informatcia?  1
What is DTM process?  3
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani  1
In which circumstances that informatica server creates Reject files?  2
What is the term PIPELINE in informatica ? Deloitte2
Which gives the more performance when compare to fixed width and delimited file ? and why? HP1
Plz..let me know differences between Informatica 7.1 and 8.1?  3
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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