Answer / anoymous

override source qualifier

select * from tablename where rownum=1 and rownum=10;

which quality process u can approach in ur project

1 Answers   CTS,

---

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

How to extract sap data using informatica?

0 Answers  

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

What is informatica? Why do we need it?

0 Answers  

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

What are the uses of etl tools?

0 Answers  

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

What are the reusable transforamtions?

1 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  

---

Clarify the aggregator change?

0 Answers  

---