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                      
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  >>  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 
what is lookupoverriding?
 Question Submitted By :: Narasimha.inf
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is lookupoverriding?
Answer
# 1		 
We can override the lookup query for a relational lookup. 
We can enter the entire override, or we can generate and 
edit the default SQL statement.
Override the lookup query in the following circumstances:
1.Override the ORDER BY statement
2.A lookup table name or column names contains a reserved 
word
3.Use mapping parameters and variables
4.A lookup column name contains a slash (/) character
5.Add a WHERE statement
 
Is This Answer Correct ?    0 Yes 0 No
Mansi
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach Virtusa4
How to extract original records at one target & Duplicate records at one target?  5
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse TCS4
What are the different types of schemas?  3
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me  2
Why use the lookup transformation ?  2
what is the process we used in joiner transformation,there is no matching column in sources?  2
wht target override?wht advantages it has compare to target update? Polaris1
What are the challenges of Dataware housing in the future? HP1
What are the two modes of datamovement in informatica sever?  1
What are the different threads in DTM process?  1
What is query panel?  1
What are the phases in SDLC?  2
What are the different options used to configure the sequential batches? Wipro1
what is meant by lookup caches?  1
what r the transformations that r not involved in mapplet? Wipro4
why dimenstion tables are denormalized in nature ?  1
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u  2
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task TCS7
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen. Accenture9
 
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