What is difference between a connected look up and
unconnected look up?

Answer Posted / rameshk

which t/r see a part of mapping is called connected
which is not part of mapping is called unconnected
the main diffrence between connected and unconnected lookup is the connected lookup connect eithere source or target but unnconnecte either nd nor connect to source or target.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of sessions are there in informatica.please explain them?

668


Name at least 5 different types of transformations used in mapping design and state the use of each.?

665


What is a filter transformation?

559


How does the aggregator transformation handle null values?

693


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1642






How to use pmcmd utility command?

574


Differentiate between Load Manager and DTM?

1655


Differentiate between sessions and batches?

564


What is a repository? And how to add it in an informatica client?

641


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1401


what is SDLC way of code development?

1553


What is the need of an ETL tool?

634


Briefly describe lookup transformation?

595


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

623


What is the need of etl tools?

600