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
- 14095 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
Partition, what happens if the specified key range is shorter and longer
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is Active lock explain
Explain lookup transformation in informatica
What is a grid in Informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Performance tuning( what you did in performance tuning)
Explain what is informatica metadata and where is it stored?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can repository reports be accessed without sql or other transformations?
What is a filter transformation?
What is DR strategy for Informatica project?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain how many types of dimensions are available in informatica?
What are the different options available for update strategy?
