Answer / suneelkumar.dasari

If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.

Answer / balu

above cases as well as if you want to get single port from
the lookup table then you should go for unconnected lookup
transformation.

Answer / g. manthiramoorthy

1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables

Answer / naresh

If we want to use multiple times in same mapping you can go
for un-connected lookup and It depends on how much data
your processing.

performance wise unconnected lookup is better because its
like reusable one and it will lookup the values only the
condition meet the criteria.

1. It will return only one value
2. It will act as static cache

Answer / kamesh

The main advantage of using an unconnected lookup is the fact that you can use it in an expression/any other transformation like a “function” in other programming languages. The Lookup Cache is calculated only once as part of the session initialization and hence more efficient, since all subsequent look-ups will re-use the Cache.

Answer / nag

To retrieve the data dynamically. And it is used for other
transformations in the same mapping.

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

Explain grouped cross tab?

1 Answers   Accenture,

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

differences between service based and product based?

0 Answers   Satyam,

What is the status code?

1 Answers  

What is xml source qualifier transformation in informatica?

0 Answers  

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

In which scenario did you used pushdown optimization?

1 Answers