How would you do mapping with flat file and Oracle as source ?

One source is flat file and other source is oracle, then how do you do the mapping?

Questions by sunitha ravula

Showing Answers 1 - 2 of 2 Answers

sppavankumar

  • Jul 18th, 2011
 

There are two possible ways of doing it:
1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping)
2) Use two different pipelines in a single mapping, where in first pipeline uses Flat file as source and second as Oracle to populate the same target or vise-versa. The loading strategy can be controlled by Target-Load-Order properties of mapping.

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions