Interested to Buy Any Domain ? << Click Here >> for more details...
Define maping and sessions?
- 3 Answers
- 8835 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Maping: It is a set of source and target definitions linked
by transformation objects that define the rules for
transformation.
Session : It is a set of instructions that describe how and
when to move data from source to targets.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / suresh
MAPPING: it is a graphical representation of data flow from
source to target which included some business
transformation logic
SESSION: It is a set of instructions that describe how and
when to move data from source to targets.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / surya
Mapping:When a Source definition transformation and Target
definition transformation are connected in a sequence
through a ETL follow of data.Such a sequence is called
Mapping.
Session:It is a task,used to migrate the data from source
to target using some instructions by informatica server is
called Session.
| Is This Answer Correct ? | 0 Yes | 2 No |
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
What is target designer and target load order?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
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.
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
can a port in expression transf be given the name DISTINCT
performance wise which one is better in joiner and lookup transformation
how to through logic of informatica using the push down optimization into oracle.
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
what is dimension table?
What is a filter transformation and why it is an active one?
Teradata 
