Define maping and sessions?

Answers were Sorted based on User's Feedback



Define maping and sessions?..

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

Define maping and sessions?..

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

Define maping and sessions?..

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

Post New Answer

More Informatica Interview Questions

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,


1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,


why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


Mention few power centre client applications with their basic purpose?

0 Answers  






Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  


what is the dashbords?

1 Answers   IBM,


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  


Difference between Data and Index Caches?

0 Answers   Informatica,


Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,


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

0 Answers   Informatica,


What is the use of incremental aggregation?

2 Answers  


Categories