What's the difference between source and target object definitions in Informatica?

  • Interview Candidate
  • 3
  • 5942

Showing Answers 1 - 3 of 3 Answers

Sravan Kumar

  • Jan 5th, 2007
 

Source system is the system which provides the business data is called as source system

Target system is a system to which the data being loads

  Was this answer useful?  Yes

saibabu

  • Jan 11th, 2007
 

source definition is the structure of the source database existed in the OLTP system . using source definition u can extrcact the transactional data from OLTP SYSTEMS.TARGET DEFINITION IS THE STRUCTURE GIVEN BY THE DBA's ,TO POPULATE THE DATA FROM SOURCE DEFINITION ACCORDING BUSINESS RULES , FOR THE PURPOSE OF MAKING EFFECTIVE DESITIONS FOR THE ENTERPRISE.

  Was this answer useful?  Yes

ggk.krishna

  • Feb 13th, 2007
 

Hai ,what Saibabu wrote is correct.Source definition means defining the structure of the source from which we have to extract the data to transform and then load to the target.Target definition means defining the structure of the target (relation table or flat file)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.