Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?
Its possible to Create 3parameters at a time?
If Possible which one will fire FIRST?
- 6 Answers
- 16474 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
Answer Posted / ebenezer
upto my knowledge, performance wise mapping parameter is
best to use, but according to requirement you can override
the mapping parameters by workflow variable(to know more
about this you can just check the workflow properties) and
session parameters are just database connections....
correct me if i am wrong.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
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 the surrogate key?
Differences between version 7.x and 8.x.
can anyone explain me about retail domain project in informatica?
Write the prerequisite tasks to achieve the session partition?
What are the different transaction levels available in transaction control transformation?
How do you take back up of repository?
Write the advantages of partitioning a session?
What is expression transformation?
What is substr in informatica?
How do you load only null records into target? Explain through mapping flow.
How many types of sessions are there in informatica.please explain them?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
