which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / m.m.basha
performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain pmcmd command usage in informatica
Performance tuning( what you did in performance tuning)
Write the advantages of partitioning a session?
whats the logic to load the lower level of granularity of data to fact table.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is incremental aggregation?
Enterprise data warehouse your projects phase by phase explain?
Name the different lookup cache(s)?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain sessions?
What is a pre-defined event and user-defined event?
What are the tasks that source qualifier perform?
What is workflow? What are the components of the workflow manager?