DSXchange

Is the platform/has LSF?

Also post Xpath used for each column.

I need the record count in a file. Yes it creates a empty file when there is no record. Am saying we need not take record count, i was explaining check whether there are any contents in file Like head command in unix, guess more +1 <file> will give first few lines of file. So in the trigger express...

thanks craig for the information. I always wondered why it happened.

1) Have you specified auto partition in the transformer stage.
2) Did you check the key option for the primary key column in connector stage.

You have mentioned there are duplicates in the source. If there are duplicates, which records must get inserted and which must be updated.

In the both the link choose the partition method as hash and provide dummy column created as key

delete empty files in after job subroutines.

To add to this make sure you make the column as key based on which records are to be deleted before insert

one thing we must be clear in this: is it file count or the record count in file Since you said reject file, even when there are no rejects empty file will be created. In that case just use type/more command or command that display file content. In the expression, check the length of command output....

What is the option you have checked?
1) Aggregate rows
2) Single Row
3) Key column

Have to? No. You just need to understand full v. relative paths and work with how your PATH environment variable is set up.

yeah we can do it. as the user was novice didnt explain

You can export the job as XML. Load the XML in to excel as XML table. By filtering out proper values in certain columns of excel like output link name of transfomer. You will get what is needed.

Export the job as XML and load in to excel, then you will get an idea what am trying to convey.

Can you please uncheck generate SQL and post the SQL that was already generated.

What all the parameters you configured in parameter tab and what is the column name mapped and paramter marker passed?

You can get entire content in a single row/line by unchecking the formatted output option in xml output stage

Thanks ray, simar.