1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Using Connected or unconnected lookup for performance wise which one is preferable?.

Question Posted / h.balaji


Using Connected or unconnected lookup for performance wise which one is preferable?...

Answer / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1 Answers  

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

normalizer transformation

3 Answers   CTS,

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

1 Answers  

What is a sequence generator transformation?

1 Answers  

what are the types of Data warehousing ?

1 Answers  

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

What is the function of aggregator transformation?

1 Answers  

What is confirmed dimension and fact?

7 Answers  

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

For more Informatica Interview Questions Click Here
Categories