What are the types of lookup?

Answers were Sorted based on User's Feedback



What are the types of lookup?..

Answer / sandeep

Differences Between Connected and Unconnected Lookup:
connected

o Receives input values directly from the pipeline.

o uses Dynamic or static cache

o Returns multiple values

o supports user defined default values.

Unconnected

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.
NOTES
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.
NOTE
- 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
large.
Performance tips:
- Add an index to the columns used in a Lookup
condition.
- 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
qualifier.

Is This Answer Correct ?    17 Yes 2 No

What are the types of lookup?..

Answer / swetha

Connected and unconnected

Is This Answer Correct ?    8 Yes 7 No

What are the types of lookup?..

Answer / rekha

CONNECTED /UNCONNECTED
CACHE/UNCACHE

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Informatica Interview Questions

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,


how to connect two or more table with single source qualifier?

4 Answers   IBM,


How big was your fact table

0 Answers  


what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,


Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,






Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  


what type of transformation is not supported by mapplets?

4 Answers   CTS,


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


How to view and Generate Metadata Reports?

1 Answers  


How do you load only null records into target?

0 Answers  


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


Categories