Explain the types of transformations?

0 Answers  

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

what is lookup ?

7 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

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  

---

How the dimensions will be loaded?

0 Answers   HCL,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---