INTERVIEW QUESTIONS DATA WAREHOUSING INFORMATICA DETAILS

Question: Define maping and sessions?

Answer: 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.

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. Source: CoolInterview.com

Mapping: It specifies how the integration service in 8.x or the power center server in 7.x will move the data from source to target through different transformations using pipelines.

Session: It is the set of instruction that tells how and when the powercenter server or integration service will move data from source to target. Source: CoolInterview.com

mapping:mapping defines the ETL rules in informatica with the of mapping objects.

session:session is an object in informatica which assigns a mapping from informatica designer to the workflow.Inside the session we need to add connection property for source and target relational database Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question