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
- 13991 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
Different sorts of metadata that stores in the storage facility?
How do you load first and last records into target table?
Explain the etl program with few examples.
Scheduling properties,whats the default (sequential)
Can we override a native sql query within informatica?
What are the new features of informatica 9.x in developer level?
what is index?how it can work in informatica
In informatics server which files are created during the session rums?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the new features of informatica 9.x at the developer level?
Describe the impact of several join conditions and join order in a joiner transformation?
What is a passive transformation?
Reusable transformation and shortcut differences
What is aggregator transformation in informatica?
What is difference between a gateway node and worker node?
