Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
Lookup() is what kind of join ?
- 6 Answers
- 12048 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 |
Can there be sub steps of etl steps?
What do you understand by the term ‘transformation’?
what are the concerns of OLTP and DSS systems?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the difference steps for data modeling?
what happens if the info.server doesn't find the session parameter in the parameter file?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Explain what is etl process? How many steps etl contains explain with example?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is the meant by Normalization and de-normalization?
Which type or t/s is used to convert rows into column & column into rows
What is a lookup table in etl?
Teradata 
