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
- 12070 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
COM components can be used in Informatica
What is a surrogate key?
Explain the etl program with few examples.
How to elaborate powercenter integration service?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the meaning of decode in informatica?
How can a transformation be made reusable?
State the differences between sql override and lookup override?
How to extract the informatica rejected data?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Informatica Checkpoints
How would you join a node to the already existing domain?
Explain why we use partitioning the session in informatica?
