lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
Answer Posted / kannan
Simple logic here,
1) SQ passes the records one by one(logical field values
eg . customer id) to lkp up t\f.
2) Then, with this logicl field values , it looks into the
database( source \target db,provided cache is disabled in
properties), fetched the records(only look up enabled
columns) and passed to the down transformation
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the fact table?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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 do we call shell scripts from informatica?
how tokens will generate?
What is domain in terms of informatica?
What is the sql query overwrite in source qualifier in informatica
How might one distinguish in the case of mapping is right or not without associating session?
What is the Rank index port in Rank transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a passive transformation?
What is meant by query override?
what is the complex transformation you used in informatica