Answer Posted / sundar
Short cut is used create copy of the object in shared
folder,that copied folder inherit changes.It maintains same
repository.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
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
can you please explain me pre session and post session options?
Differentiate between a database and data warehouse?
What are the different types of repositories created using informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain the features of connected and unconnected lookup.
Please let me know how to make encryption and decryption with example?
What is a surrogate key?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain constraint based loading in informatica
What is the advantage of informatica?
What do you mean by filter transformation?
How can we improve session performance in aggregator transformation?
