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

Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?

Question Posted / sunil

Answer Posted / sunil

Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..

If anything wrong pls let me know...am looking for job..

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain and gateway node?

800

Performance tuning in UNIX for informatica mappings?

2246

What is primary and backup node?

802

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1314

What is meant by lookup transformation?

697




In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1624

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8117

What are the restrictions of union transformation?

672

 Informatica Checkpoints

2943

explain one complex mapping with logic? sales project?

6288

On which transformations you created partitions in your project?

870

What is union transformation?

662

wf dont have integration severances how you can run?

1617

What you know about transaction control transformation?

645

Difference between Target-based loading and constraint-based loading?

645