What is a diff between joiner and lookup transformation
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
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Different qualification between a related rotate toward the sky and isolates look upward?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is enterprise data warehousing?
Define enterprise data warehousing?
How can we store previous session logs?
What is the way to execute pl/sql script using informatica mapping?
How do you load alternate records into different tables through mapping flow?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Is stop and abort are same in informatica?
What is informatica worklet?
Where can we find the throughput option in informatica?
How you prepared reports for OLAP?