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.

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

What is parallel processing in informatica?

0 Answers  

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

What is repository manager?

0 Answers  

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

How to recover the standalone session?

2 Answers  

what are objects in data warehouse?

2 Answers   Mind Tree,

What is informatica etl tool?

0 Answers