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 |
Where is the cache stored in informatica?
Can we combine a flatfile and a database table using an UNION transformation?
How to recover sessions in concurrent batches?
What is source qualifier transformation in informatica?
What are the different lookup cache(s)?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
what is the function of 'F10' informatica ?
What is DR strategy for Informatica project?
What are the features of complex mapping?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is dimensional table? Explain the different dimensions.