Can you copy the session to a different folder or
repository?
Answer Posted / praveen kumar
we can, but we have to copy the mapping first and then we
have to copy the session....
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
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 SDLC way of code development?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
lookup transformation with screenshots
Explain sessions. Explain how batches are used to combine executions?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the modules in Power Center
What is domain in terms of informatica?
Explain how many types of dimensions are available in informatica?
How to load last n records of file into target table - informatica
How to load the data from people soft hrm to people soft erm using informatica?
Define joiner transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?