Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kshetra
using verbose data in the session properties
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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 joiner change?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What happens when a session fails and you click on recover?
expain about the tune parameters?
What is the meaning of decode in informatica?
What are the tasks that source qualifier perform?
How do you load unique records into one target table and duplicate records into a different target table?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is decode in informatica?
Explain incremental aggregation in informatica
What the difference is between a database, a data warehouse and a data mart?
What is a sorter transformation?
What are the static cache and dynamic cache in informatica?
