when we go for unconnected lookup transformation? and why?

Answer Posted / arvind

When we want to get single return value, and also we can
call this anywhere in the mapping
In addition to this it gives u the flexibility to run
lookup for selected source rows which u dont find in
connected lookup

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by pre and post session shell command?

628


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1636


what is song in infrmatica...?

1680


What are the new features of Power Center 5.0?

1234


How can we store previous session logs?

569






Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

630


Explain the difference between mapping parameter and mapping variable?

606


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

679


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1611


What is data caches/ index caches?

615


While importing the relational source definition from the database, what are the metadata of source that will be imported?

795


How to generate sequence numbers using expression transformation?

646


What is the need of etl tools?

615


On which transformations you created partitions in your project?

763


Explain in detail about scd type 1 through mapping.

591