in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?

Answer Posted / sid

I think we can use agg t/f and rank t/f for this
we cant use filter ,update strategy t/f becoz in these two
we wright the condition in conditions tab but not in ports .

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the prerequisite tasks to achieve the session partition?

737


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

649


Under what conditions selecting sorted input in aggregator will still not boost session performance?

717


How can we use batches?

686


How do you manage the Parameter files while migrating your data from one environment to another environment?

653






What do you mean incremental aggregation?

716


What is lookup transformation?

703


Where can we find the throughput option in informatica?

700


Explain the difference between mapping parameter and mapping variable?

705


What are the restrictions of union transformation?

672


What are the designer tools for creating transformations?

774


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6153


Which means the first record should come as last record and last record should come as first record and load into the target file?

695


Differences between connected and unconnected lookup?

729


How you know when to use a static cache and dynamic cache in lookup transformation?

1424