Interested to Buy Any Domain ? << Click Here >> for more details...
in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
- 9 Answers
- 20543 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / anil
u can use any T/r based on Exp editor available in which
t.r that t/r u can use .lkp value.u can use
update ,agg,rank,filter,sq
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many types of sessions are there in informatica.please explain them?
What is a rank transform?
Is it possible to use a client with different version than that of its Informatica server?
Different circumstance which drives informatica server to expel records?
What is a repository manager?
Under what condition selecting sorted input in aggregator may fail the session?
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 you validate all mappings in the repository simultaneously?
Do you find any difficulty while working with flat files as source and target?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How does the aggregator transformation handle null values?
Explain the scenario which compels informatica server to reject files?
What are the components of the workflow manager?
What's the layout of parameter file (what does a parameter file contain?)?
During the running session, output files are created by informatica server. Enlist few of them.
