Flat files

Get new comments by email
You can cancel email alerts at anytime.
Comments (2)

Krishna in Franksville, Wisconsin

94 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?

- Was this comment helpful? Yes (8) / No (2) Reply - Report abuse

Mallikarjun in New Delhi, India

63 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.

- Was this comment helpful? Yes / No Reply - Report abuse

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