Define Pmrep command?

0 Answers  

---

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

Explain what are the different versions of informatica?

0 Answers  

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

How can we create index after completion of load process?

0 Answers  

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---