DSXchange

it will be something like this...


Switch Stage-->Copy Stage (in place of Seq file)

And from copy stage, drag two links ...one for Sequential File and one for your join stage.

viewtopic.php?t=127274&highlight=last+month

Hope this will help

CFF (complex flat file) is a kind of file available under datastage palettel/Files category.
But, I am not sure whether it will fulfill your requirement or not. I never used it.

Use

StringToTimestamp((<Field_Nmae>,"%yyyy-%mm-%dd %hh:%nn:%ss")

%nn is the correct one for month.

No. There is no other way.

Better create different project for TEST and UAT.

Usually, Unit testing covers the testing of individual job/sequence. We need to ensure whether the job is completely performing the task, what it is supposed to do. It should fullfill all the business logic coded in the job. We should prepare the test cases corresponding to all key logic coded like ...

'update when there is a delete'

Change capture performs delete when there is a delete ideally. It does what it is supposed to do.

Alternatively, you can validate the value of change_code=2(Delete) in filter/transformer stage after change capture and can perform the update operation.

why are you creating multiple datasets. Just use the single dataset for all of your lookup's.

1. If doing multiple lookup's in the same job then use the copy stage.
2. If doing lookup's in separate job's then no need to create copy of dataset. Use the original one.

You can not view data of lookup fileset. No such utility exist.

Please describe your problem in details....where are you viewing data, in which stage???

Specify your requirement clearly. What type of source it is.

1. Databases have their respective functions to deal with NULL.
2. Sequential file don't have datatype.
3. Transformation functions are there.

Please specify your requirement.

You can't create the column name with spaces in between.

If you would like to show it in your .cvs file can work with ways Guru's suggested.

DS doesn't have the version control. One can manually maintain it.

Use of Version Control tool can help to maintain the different versions of the code.

Play with Stage Variables and assign the value as per your requirement. Check the nullability of all the output columns in stage variable and assign flags 'T' or 'F' to the stage variable. Also, check the required format of date. Then, in the constraint section, check the stage variable flag value f...