Interested to Buy Any Domain ? << Click Here >> for more details...
which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 11795 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 78swapnil
All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is target designer and target load order?
In which transformation you cannot drag ports into it?
Quickly characterize reusable change?
What are the new features of informatica 9.x at the developer level?
According to his methodology what all you need before you build a datawarehouse
What are the uses of etl tools?
What is depict expression change?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What could be the possible resons of locks by user?
Enlist the tasks for which source qualifier transformation is used.
What is a connected transformation?
Difference between Target-based loading and constraint-based loading?
What are the prerequisite tasks to achieve the session partition?
What is the difference between a repository server and a powerhouse?
