Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6034 Views
- I also Faced
- E-Mail Answers
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 |
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Quickly characterize reusable change?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Can yoU use the maping parameters or variables created in one maping into another maping?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
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.
what are surrogate keys?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
what type of transformation is not supported by mapplets?
What if the source is a flat-file?
Please let me know how to make Data masking in informatica..
Teradata 
