Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the surrogate key?
What are the settings that you use to configure the joiner transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Slowly changing dimensions, types and where will you use them
What is data caches/ index caches?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an aggregator transformation?
What is the need of an ETL tool?
What are the tasks that can be performed using sq?
What is primary and backup node?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How do you load first and last records into target table?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
