How do you create single lookup transformation using
multiple tables?
Answer Posted / murali vishnuvajhala
you cannot join two tables in a lookup. Lookup works only
on one underlying table.
Is This Answer Correct ? | 4 Yes | 34 No |
Post New Answer View All Answers
Explain your project of banking domian.
Global and Local shortcuts. Advantages.
Explain in detail about scd type 1 through mapping.
What are session parameters ? How do you set them?
What are the advantages of informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
Which is the t/r that builts only single cache memory?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the shared cache and re-cache?
How many input parameters can exist in an unconnected lookup?
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
What is pmcmd command?
What is persistent lookup cache?
What is a filter transformation?