when we go for unconnected lookup transformation? and why?
Answer Posted / guduri hari
When we want to get single return value,we can call this
anywhere in the mapping...
> when no.of recs are less go for unconn lkp, which improve
the performancee
unconnect give performance edg
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data movement mode in Informatica and difference between them?
Is it possible to create multiple domains on a single Informatica server?
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?
Mention some types of transformation?
Name the different lookup cache(s)?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Did u used latest transformations of 8.6.0? for what?
Enlist the various types of transformations.
How does a sorter cache works?
What are the issues you have faced in your project? How did you overcome those issues?
In informatica workflow manager, how many repositories can be created?
Suppose we do not group by on any ports of the aggregator what will be the output?
Difference between Target-based loading and constraint-based loading?
What is a dimensional model?
In how many ways we can create ports?