:: Home Page            
 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                      
Categories >> Software >> Data Warehouse >> Informatica


 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
What are the types of lookup?
 Question Submitted By :: Informatica
I also faced this Question!!     Answer Posted By  
# 1
Differences Between Connected and Unconnected Lookup:

o Receives input values directly from the pipeline.

o uses Dynamic or static cache

o Returns multiple values

o supports user defined default values.


o Recieves input values from the result of LKP
expression in another transformation
o Use static cache only.
o Returns only one value.
o Doesnít supports user-defined default values.
o Common use of unconnected LKP is to update slowly
changing dimension tables.
o Lookup components are
(a) Lookup table. B) Ports c) Properties d) condition.

Lookup tables: This can be a single table, or you can
join multiple tables in the same Database using a Lookup
query override.You can improve Lookup initialization time
by adding an index to the Lookup table.
Lookup ports: There are 3 ports in connected LKP
transformation (I/P,O/P,LKP) and 4 ports unconnected LKP
(I/P,O/P,LKP and return ports).
o if youíve certain that a mapping doesnít use a
Lookup ,port ,you delete it from the transformation. This
reduces the amount of memory.
Lookup Properties: you can configure properties such as SQL
override .for the Lookup,the Lookup table name ,and tracing
level for the transformation.
Lookup condition: you can enter the conditions ,you want
the server to use to determine whether input data qualifies
values in the Lookup or cache .
when you configure a LKP condition for the transformation,
you compare transformation input values with values in the
Lookup table or cache ,which represented by LKP ports .when
you run session ,the server queries the LKP table or cache
for all incoming values based on the condition.
- If you configure a LKP to use static cache ,you
can following operators =,>,<,>=,<=,!=.
but if you use an dynamic cache only =can be used .

- when you donít configure the LKP for caching ,the
server queries the LKP table for each input row .the result
will be same, regardless of using cache
However using a Lookup cache can increase session
performance, by Lookup table, when the source table is
Performance tips:
- Add an index to the columns used in a Lookup
- Place conditions with an equality opertor (=) first.
- Cache small Lookup tables .
- Donít use an ORDER BY clause in SQL override.
- Call unconnected Lookups with :LKP reference
Is This Answer Correct ?    15 Yes 2 No
# 2
Connected and unconnected 
Is This Answer Correct ?    8 Yes 7 No
# 3
Is This Answer Correct ?    3 Yes 5 No

Other Informatica Interview Questions
  Question Asked @ Answers
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me   2
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way? Zensar 2
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance. CTS 7
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please.. TCS 3
What are the types of maping wizards that r to be provided in Informatica?   2
8.what is mapplet ?give example?   2
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ? IBM 6
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join? IBM 2
What is query panel?   1
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)? Wipro 10
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance.. Wipro 4
explain about informatica server architecture? IBM 1
For more Informatica Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright © 2013  All Rights Reserved.   ::