DSXchange

think it's Carriage return charater, Check ur source file with text pad for better understanding file format(i.e record, line and EOF delimiters.

Are you getting this chracter along with "BIN" column?? what is the record delimiter used? is this UNIX or windows file?

Yes, assuming primary link as left link (i.e left table), select options Keep/drop for unmatched records.

Can you pls check weather u have selected "Run Before and after SQL statements" to YES. or somebody else might have opened the job???

We are in datastage version 8.1, i guess your answer is correct for Datastage ver 8.5

RAW(n) datatype not supported in datastage oracle connector, So CLOB datatype may also not supported. If oracle record length exceeds 32KB then job aborts...Pls advice if wrong.

Q1: Yes, Four instances will create
Q2:Yes, I guess you are correct

Hi,

sorrogate key used to preserve referal integrity, tht's the answer!

Hi,

No records in your table or DB you are retriving.,

regards,
Bharat

Hi,

Which Version you are using, like DS Enterprise edition. in this you can design server as well as parallel jobs and Mainframe jobs also.

Regards,
Bharat