DSXchange

From the look of it, it might be 'freezing' because the peek window is opening outside your system monitor. Try ALT+SPACE and select maximize on the window. It does not make sense that only PEEK stage freezes the client.

The datatype of calculated filed in aggregator will always be float. Is is not Decimal but you can do a conversion in transformer stage after the aggregation. Use DfloatToDecimal() function.

Change capture takes the before dataset (i.e. the existing table) and compares with the after dataset (i.e. the new records) and produces flags depending on the comparision. These flags are in a field named Change_code. The values of code represent the state of data like copy (already existing), Ins...

You cannot update a field unless a key is defined in the statement. If you have a single column i wonder how you can update it. i am assuming you might want to check if the value already is existing in the table and insert the new records. In that case try Change capture.

You can do the three looks ups in three different lookup stages with the 'lookup failure' condition as continue. You are then affectively doing a left outer join on all three stages, you can capture flags in the three lookupsatges that meet the criteria and apply the required condition in a transfor...

The SCD stage does not exist in 7X, you can use change capture in conjunction with Insert/Update

Try to include more information when asking something, like are the queries being run in the same or different jobs, how is the sequencer setup etc...
The queries can be parametized and/or the sequence can be manuplated to achieve your request

If you still want to write NULL in to the fixed width file then try 'NULL ' in the CHAR(10) field

What type of file are you reading - Fixed width/ Delimiter, do you have any double quotes in the data. did you define any record delimiter (Unix Newline/ DOS format). Post the particluars for the readers to understand please.

While using Remove duplicates sort by Field1 (ASC) and Amount (DESC) on the input link and use Field1 as the Key. This should work.

Try This:

Input Tab, Partitioning Tab: Same

instead of Auto.

If the source data is from database try to cast it in the sql itself as a number. Use TO_NUMBER function and read it directly as integer in datastage. This will remove the leading '0' and the key fields will be integer.