Hi frndz, "while i am going to run the infotmatica power
designer,he ask the id and password ",then i enterd the id
and passwd , at that time i got the error as " failed to
connect repository " ?
Answer Posted / rajan raorane
Repositary you are trying to connect is not enabled
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
Mention a few design and development best practices for informatica?
What is data transformation manager process?
Clarify the aggregator change?
What is native users?
Can we override a native sql query within informatica?
Differentiate between router and filter transformation?
How many types of sessions are there in informatica.please explain them?
What is a predefined event?
How do you set a varible in incremental aggregation
What is the use of target designer?
Can we create multiple integration service on single repository?
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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a difference between complete, stop and abort?