Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Differences between connected and unconnected
lookup?
- 6 Answers
- 20911 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / swetha
Connected lookup
Unconnected lookup
Receives input values diectly from
Receives input values from the result of a
the pipe line.
lkp expression in a another transformation.
yoU can use a dynamic or static cache U
can use a static cache.
Cache includes all lookup columns Cache
includes all lookup out put ports in the
used in the maping
lookup condition and the lookup/return port.
Support user defined default values Does
not support user defiend default values
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Which version configuration tool used in ur project?
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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
how many types of dimensions are available in informatica?
What are junk dimensions?
What is intricate mapping?
How you know when to use a static cache and dynamic cache in lookup transformation?
Can you use flat files in Mapplets.
What are the databases that informatica can connect to windows?
How can we update a record in the target table without using update strategy?
What is target load order?
How can we delete duplicate rows from flat files?
What is the need of etl tools?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
In informatica workflow manager, how many repositories can be created?
