Define maping and sessions?
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 |
wt is Dynamic lookup Transformation? when we use?how we use?
Where are the source flat files kept before running the session?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
Without using Lookup & Sequence Generator, How to generate Sequence?
wf dont have integration severances how you can run?
What are the join types in joiner transformation?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
scenario where i can use only concurrent execution of workflow.
what is the difference between static and dynamic
How to generate the HTML output using Informatica.