Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
- 5 Answers
- 8604 Views
- I also Faced
- E-Mail Answers
Answer Posted / rayudu
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What are the components of the workflow manager?
Define Pmrep command?
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
where to store informatica rejected data?
How to extract sap data using informatica? What is abap? What are idocs?
According to his methodology what all you need before you build a datawarehouse
Explain what are the different types of transformation available in informatica.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
While migrating the data from one environment to another environment how would you manage the connections?
How are the sources and targets definitions imported in informatica designer?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are junk dimensions?
