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 |
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)?
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 ?
What are the circumstances that infromatica server results an unreciverable session?
Mention few power centre client applications with their basic purpose?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is the dashbords?
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?
Difference between Data and Index Caches?
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.
Design a mapping to load a target table with the following values from the above source?
What is the use of incremental aggregation?