Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 9796 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / zak
Yes, we can use Lookup to join 2 tables. Lookup performs
Left Outer Join by default.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sunil
Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..
If anything wrong pls let me know...am looking for job..
| Is This Answer Correct ? | 5 Yes | 1 No |
How to recover the standalone session?
Two Default User groups created in the repository are ____ and ______
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
Enlist the tasks for which source qualifier transformation is used.
In session log thier should not be a single error how will u do
how to connect two or more table with single source qualifier?
How u use pdf file in informatica source?
What is Code Page Compatibility?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
Teradata 
