implementig job using join

[4friends]

i have two source files


in souce one i have (1,2,3)

in source 2 i have (1,2,4)

i need target like 3 files in first file(1,2)
2nd file (3)
3rd file (4)

how can we implement plz send me a solution to this.

[ray.wurlod]

Create a source-to-target mapping document. For every column in each target file create a specification about how its value is to be obtained. You can use a table in a spreadsheet or a word processing document, or FastTrack if you have that.

The rest (the ETL design) will follow with great ease.