Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts,
Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.
Thanks In Advance.
- 2 Answers
- 13850 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / raj
the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What is meant by a domain?
What is the use of source qualifier?
How to differentiate between the active and passive transformations?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you load unique records into one target table and duplicate records into a different target table?
what is size of u r database?
What are the measure objects?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain in detail scd type 2 through mapping.
What are session parameters ? How do you set them?
Explain the different kinds of facts.
What happens when a session fails and you click on recover?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is meant by LDAP users?
Write the program through which the records can be updated?
