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


Please Help Members By Posting Answers For Below Questions

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976


how to load dimension table and fact table. plz tell me the steps.

1687


update strategy transformation in informatica

644


Explain constraint based loading in informatica

661


Performance tuning in UNIX for informatica mappings?

2145






how to load rows into fact table in data warehouse

642


How do you promote a non-reusable transformation to reusable transformation?

663


How can we create index after completion of load process?

600


How to implement security measures using repository manager?

608


What is flashback table ? Advance thanks

1481


What is the commit type if you have a transaction control transformation in the mapping?

654


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?

1751


hi real timers . iam waiting for ur reply regarding ETL TESTING

1812


To import the flat file definition into the designer where should the flat file be placed?

679


How to load the data from people soft hrm to people soft erm using informatica?

564