Answer / aa

Place the xml template in the MappingTemplate folder in ur C drive

u can refer more info below as well as Informatica KB

https://etltechsolutions.wordpress.com/2016/02/09/informatica-visio-table-definition-not-found-exception-error/

Define Update Override?

1 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

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,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

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  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---