DSXchange

There is only one type of sequential file. It consists of a byte stream possibly including bytes that have special meaning.

When's the interview?

You have embedded newline characters in an unquoted field. You either need to get whoever is supplying you with this file to wrap that field in some kind of quote character, or figure out some other way to identify the end of the record. For example, if ".." really does end the record, the...

Thank you for sharing that.

If you have any problem, that description does not convey what it is, other than you may be looking at redesigning a job. There's a word for that - "maintenance".

There is no limit.

But the operating system may have a limit.

Is this null or the word "NULL"?

How are you generating the null within your DataStage job?

In a Transformer stage you should be using the @NULL system variable.

What stage type are you using when updating SQL Server?

Just remove the Unicode extensions. They are put in there automatically (and annoyingly) because you have NLS enabled and are creating table definitions within the job design.

Check the record schemas in the generated OSH to find out where they're being used.

1) Yes
2) Yes, but it's not the only location: there is also a local repository on the engine tier, used particularly while jobs and other components are being designed/edited.

Welcome aboard. We firmly believe that anyone undertaking an interview should succeed or fail on their own merits. While recognizing your initiative in attempting to research the questions here, we feel that it is not right (or moral) for you to go into an interview armed with anyone else's knowledg...

Anything locked on the DB server? Are both sets of jobs writing to the same table(s)?

Create in-band nulls simply by assigning the chosen null-representing value.

You use a trigger on the Job activity.

This is stock standard sequence programming 101.

Does the executing user have INSERT privilege to that table? Please post any error message that has been reported.