What is a diff between joiner and lookup transformation
- 16 Answers
- 90947 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / shiva shankar naidu n
1.Join supports all types of joins, but lookup supports only
two types of joins supports like inner and left outer only..
2.join not provided rejected link, but lookup provided it.
3.join is high sorting speed but not lookup.
4.join takes huge amount of data from two tables, but look
up not supported to data than source table.
5.In lookup Reference data always less than source data
other wise its not suppoted.
6.lookup always based on condition, but not join stage.
7.join common column must be same, in look up no need common
column name.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
explain one complex mapping with logic? sales project?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are Dimensional table?
generate date / time dimension in informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the types of presistent cache in look up tr.
What is a mapplet/worklet in informatica?
What is the difference between router and filter?
What is the sequence generator transformation in informatica?
Explain sessions and how many types of sessions are there?
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
What are the mapping parameters and mapping variables?
How to handle decimal places while importing a flatfile into informatica?
can u give example for factless fact table
