Flat files

Comments (2)

Krishna in Franksville, Wisconsin

99 months ago

There are two different tables from two different SQL server database in my source and I need to populate the updated records in the target. My target contains two flat files(customer & product) and I need to populate updated records of customer records to customer flat file and products records to product flat file. How do i start my mapping? I dont know whether there is an matching column in the source or not? If there is no matching column how do i join the source tables? Could anyone suggest me regarding this?

Mallikarjun in New Delhi, India

68 months ago

if dont have matching column in ur source tables then u can create dummay ports and u can join.

or else single in Source quilifier we can join by specifing schema of taht tables.

» Sign in or create an account to comment on this topic.