If we set dd_insert in mapping and Delete in session properties what will happen.?
Answers were Sorted based on User's Feedback
Answer / sweta kedia
Yes it will perform delete as session properties overrides
mapping properties.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / insha
It will perform delete operation since session defines run
time properties of mapping
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / usha
It will perform delete.
because session properties overide mapping properties.
Is This Answer Correct ? | 3 Yes | 1 No |
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
What is dimensional table?
State the limitations where we cannot use joiner in the mapping pipeline?
Differentiate between router and filter transformation?
what is $$$$?
differences between service based and product based?
what is mean by complex business rule ?
how to get the only updated records in the target
What are the popular informatica products?
can you use flat file for lookup table?why?
How we can confirm all mappings in the repository simultaneously?
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.