DSXchange

For the second option DSguru2B, you can use Staging table to retain the last run data, rather than doing a lookup against the full target data. If you requirement specifies for last and current load.

Its fine if you scripts is already working. Declaring variable wont have space in close to "=".
FILE2 = /Ardent/EDWDev/DataKC/EDWD130AUDIT_Completed
May be you might have just give for example, if so leave it.

Try with two WaitForFile activity connected to Sequencer with "Any" as trigger. One which waits for ABC.txt and followed by the required logic, and then to Sequencer. And the other WFF stage for XYZ.txt and directly to Sequencer. So that, if XYZ.txt comes, it reaches the Seqencer and you can finish ...

How are you making datastage to wait for a file? Using WaitForFile activity or using script ExecuteCommand activity? If you are using ExecuteCommand Activity as you mentioned, you can change you script to wait for both and proceed with the logic, if you find any one of them. You can frame a loop, an...

How are you populating the table?
Check the source data that used to populate the data. Check if any transformation logic involved which appends any special character or a space or newline character or tab character at the end of it.

Why do you need to abort it anyway. If there is no records, dont execute it, and notify or do whatever. You can do this in a Execute command activity to populate a file. And using "test -s newfilename", you can check the file size and based on the result, you can execute the job or you can trigger t...

An empty string will be passed as parameter, and hence the result of the your code will return an empty values to standard output, and that was read as input by the sequential file stage.

There is not document given for each stages, but you can find you self by producing the scores. Set APT_DUMP_SCORE in your job and look for the scores, it will show you the details.

It depends on the function and parameter that you use, %mmm will give you Three character month abbrevation, %mm will give you 2 letter numerical representation of the month.

Hi Kalai,

Welcome aboard :D !!!
And thanks for sharing your solution. You can post the inputs that you got from IBM, once you receive it.

Narasimha have reached 1000 posts.
The next Popping up star.
Great work.!!!!

Correct.

What is the database, you should also have another option where you can check the change in updated timestamp in its corresponding log.

I guess, its your output dataset points to the After Dataset as input, and hence it might be showing as Copy.

If it is previously sorted, you can as well include an environmental variable to avoid the auto sorting. APT_NO_SORT_INSERTION.