DSXchange

When's the interview?

Automatic.

What are your sampling specifications when you use View Data? If you specify only 10 rows, that's all you'll get.

How is this post different from your other post? One is marked version 8 and one is marked version 7, but I doubt that you have both.

No, because there is no mechanism for discovering the data types. If you want to declare everything to be string[max=n] (that is, VarChar), how will you determine the correct values for n? No stage "stores" a record schema - you can write the record schema to a file and have certain stages...

Use a big block size. Don't be afraid to use 100000 or even 1000000. A block size of 1 has to read the state file for every record processed.

Set up a previous job to initialize the state file to the start value you want.

What's the data type? -1 is a valid value for any signed data type.

REDEFINES means "different columns" - you have a different structure (2,2,2,6 versus 2,2,8). The CFF stage can deal with the REDEFINES - you specify the particular output columns that you require.

It's because the viewing of logs issue has been resolved that we want you to forget this thread and open a new one for your Monitor issue, which has a different solution.

My admittedly inexpert take on this is that WTX is intended for real-time (and therefore small volume) transformations.

Is runtime column propagation (RCP) enabled or disabled?

Please mark as Resolved using the green button at the top of the screen.

Just a thought - there may be a solution using the SCD stage.

Data elements Date and Time will cause automatic conversion to/from DataStage internal format when used in the ODBC stage.