DSXchange

What is the code you used in Batch file?
Is the password been passed at the same command that been executed as a parameter to the sftp command?

Anupam - Is your 'Automatically handle activities that fail' option enabled?

Is by any chance, that you guys have decided not to give solutions with DS internal files.

So what is the difficulty you faced in DS.
Pass username@hostname and password as parameter to sftp.

Is the value Diana and 10 aer fixed?
Or can you parameterize it?
You can simply achieve this using transformer with If-Then-Else condition.

What is the exact code you use?
Is you command getting executing from command line?
Is your connect statement and ftp statement in different segment?

Use transformer to call the routine, pass on the packed decimal column as the argument to this routine and map to integer.
If NLS is enabled in your project, make your source map as none.

As mentioned have two stage variable.

Initial declaration
Old = ''
New = ''

Stage variable derivation
Old = New
New = Input Column.


If Old = New Then {logic for duplicate} else {logic for new}

If we partition the data using all three keys in order zip,age,apt on two nodes ,does all records with zip 48201 arrive on the same node always. Not necessarily.... If you mark all the three column as key for hash partition, the partiton will be done on the accumulation of all the three columns. He...

Make sure the error prompting is particular to that single job and not to other job that exist in that project. If creeps to others, you are in soup.

If your post is the last in that thread, you can used 'Edit/Delete the post' to delete. But not after an update by others.

Do you find any level change in the field properties available in the transformer?

sravanthi wrote:Hi all,

Thanks for your suggestion.I have used remove duplicate stage and used retain last column it worked fine.

thanks! :D

Make sure your data is sorted and partitioned on the key before using RemoveDuplicate stage.

This gives the last record. If you need the last record no, simply count the total no of record using aggregator.

##W TFPA 000012 20:05:49(000) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE job does not start up correctly, please set your PWD variable to a value that will work on all nodes of your system. Try inse...