Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dfg
dfgdsfg
| Is This Answer Correct ? | 0 Yes | 20 No |
Post New Answer View All Answers
Is there any way to read the ms excel datas directly into informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Write the program through which the records can be updated?
How can we use mapping variables in informatica? Where do we use them?
Repository user profiles
How is union transformation utilized?
Explain in detail about scd type 1 through mapping.
What are the different ways to implement parallel processing in informatica?
Which files are created during the session rums by informatics server?
What is exclusive and normal mode for repository services?
What is blocking transformation?
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
Describe expression transformation?
Informatica settings are available in which file?
What are the different clients of powercenter?
