Answer / ande

Connected LookUp returns multiple values to other
Transformation whereas unconnected lookup return single
value, If condtion is match then connected lookup returns
user defined default values whereas unconnected lookup
returns null values, connected lookup supports dynamic as
well as static caches whereas unconnected lookup supports
static cache only
regards,
ande

Answer / prasuna

1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.

An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.

2)IN connected The Integration Service passes return values
from the query to the next transformation.

In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.

3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache

Answer / suresh

1.conneted T/r takes multiple inputs and gives multiple
outputs
where as unconnected t/r takes multiple inputs but gives
single output

2. in connected lookup input, output, lookup ports are
available
where as in unconnected look up having input,output,lookup
as well as return port

3. connected t/r used dynamic and static cache
where as unconnected t/r uses only dynamic cache

Answer / parveen kumar

The imp. diff b/w connected and unconnected lookup is regarding to their performance. Suppose if a lookup condition is true only for one thousand rows out of 1M rows. Then we must use unconnected lookup in such cases by calling the lookup only in else condition i.e. we can write in EXP that if ID(suppose this is I/N port)is null, then -1 else :LKP.(lookup transformation name). So in this case, it'd hit the DB only 1000 times. But if we use connected lookup, it'd hit the DB 1M times no matter whether the condition is true or not.

Answer / rameshk

which t/r see a part of mapping is called connected
which is not part of mapping is called unconnected
the main diffrence between connected and unconnected lookup is the connected lookup connect eithere source or target but unnconnecte either nd nor connect to source or target.

Answer / mln

connected look up is not reusable and only one output port
are return port will be there at a time and this is more
faster than connected.

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

WHat all joins are there in Source Qualifier?

1 Answers  

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

what is fact table?

9 Answers  

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

What are the types of data warehouses?

0 Answers   Informatica,

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

what is lookupoverriding?

1 Answers