Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kunkala.ramakrishna
IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES
YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is substr in informatica?
How can informatica be used for an organization?
What does role playing dimension mean?
generate date / time dimension in informatica
Define sessions in informatica etl?
what is INFORMATICA TESTING process
What is the benefit of partitioning a session?
On which transformations you created partitions in your project?
Can informatica load heterogeneous targets from heterogeneous sources?
What is olap (on-line analytical processing?
Explain informatica architecture - version 8 / 9
What is the use of an aggregator cache file?
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 are the different clients of powercenter?
Explain sessions and how many types of sessions are there?
