Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between connected and unconnected lookup?
- 5 Answers
- 8963 Views
- BirlaSoft, Blue Star Infotech, I also Faced
- E-Mail Answers
Answer Posted / naidu.k
Connected Lookup
Its can recieve multiple input ports and returns
multiplepoutputorts
it is part of mapping data flow
when lookup condition no match Data the integration services
returns insert the data
when lookup condition match Data The integration services
returns update the Data
default values supports
UNConnected Lookup
Its not part of mapping data flow it can recieve multiple
input ports and return single output ports.
when lookup condition no match data the integration services
returns null values
when lookup condition matchdata the integration srvices
returns update data
default values removed
I
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can a transformation be made reusable?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the settings that you use to configure the joiner transformation?
What is union transformation?
What is DR strategy for Informatica project?
What is resilience time?
What is the function of union transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is meant by target load plan?
tell me the rules and responsblites in our project(my project is development)
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How can repository reports be accessed without sql or other transformations?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
