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.

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

In ur current projectu have done any performance tuning of mappings?

1 Answers  

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

How many cubes create from a single model?

1 Answers  

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

When do you use sql override in a lookup transformation?

0 Answers  

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

0 Answers   Patni,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

What is a poling?

2 Answers