Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95928 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 are the different options available for update strategy?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Could you explain what is enterprise data warehouse?
How to update a particular record in target with out running whole workflow?
expain about the tune parameters?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is the hint? how to use it to reduce the query processing in program?
What is a connected transformation?
Different sorts of metadata that stores in the storage facility?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can one identify whether mapping is correct or not without connecting session?
server hot-ws270 is connect to Repository B. What does it mean?
What is dimensional table?
