Hi,
Lookup() is what kind of join ?
- 6 Answers
- 10245 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vamse
not necessarily left outer join. Its inner join most of the time.
Loop up is generally used to fetch data for a particular filter condition.(matching critria should take a particular value from it.
Main table is usually large and look up table is small in ideal scenario.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / ravikumar
Hi,
You can Say LookUp is a Left Outer join.Your Source Table is
Left side table and Lookup table is right table.
Now you are trying to get total source records and
matching records from lookup table(right table).
Hope this helpls....
ravikumar.pasupula@outlook.com
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / ankit kansal
Lookup is used to check whether the row corresponding the incoming row is present or not and if yes then perform some logic and if not then do some other like we use to do it case of SCD2.
So, It is purely a left outer join where left table is your source table.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ashish
Lookup by default perform normal join but if you want to achieve left outer ,right outer , full outer join . you can do so by SQL override in lookup
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sunil
Lookup works as Master outer Join in informatica ..
Oracle--> its works as left outer join..
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / hemant
Lookup is used to be a inner join but starting from the
version 9 it is behaving as a left outer join.
| Is This Answer Correct ? | 1 Yes | 3 No |
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Mention few test cases and explain them?
without using ETL tool can u prepare a Data warehousing and maintaining?
What are the modules in Power Mart?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Explain etl?
What is abap? What are idocs?
what is pmrep command?
what is an ETL or ETT? And what are the different types?
what is the difference between shortcut of an object and copy of an object? compare them?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
What are the various tools used in etl?
Teradata 
