when i try to connect to the repository server i am getting
this message can someone help me..
Starting Repository [infa_rep]
(6016|1292) Informatica Repository Agent, version [7.1.1],
build [0811], 32-bit.
(6016|1292) Copyright (c) 2000-2004 Informatica Corporation.
All Rights Reserved. This Software is protected by U.S.
Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158;
5,794,246; 6,339,775 and other U.S. Patents Pending.
(6016|1292) Informatica Repository Agent starting up.
(6016|1292) Security audit trail has been turned off.
(6016|1292) infa_rep: Repository runtime manager initialized.
(6016|1292) infa_rep: Initialized configuration information.
(6016|1292) infa_rep: Initialized request dispatcher.
(6016|1292) Database Connection Error : Failed to logon to
Database server
ORA-12154: TNS:could not resolve service name
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user []
and connection string [].
(6016|1292) Service stopped.
Answer / dheeraj
check the oracle connection string, if you have given the
service name check the entry in your TNSname.ora file in
oracle installation dir.
Try connecting using sqlplus and if success use the same
details in the repo to connect.
Is This Answer Correct ? | 0 Yes | 0 No |
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
What is the difference between bitmap and btree index?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
Difference between task flow and linear task flow
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What is the difference between Active and Passive transformation?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
What you know about transaction control transformation?
hi all, Can anyone please tell me the relationship between informatica and business objects
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?