DSXchange

Or create a Environmental varialbe which will be configured for each project, to the home directory of that corresponding user. And pass this variable as parameter to the shell and source the .profile for each time, so that you can ensure that the user specific variable is used.

Check the pdf given and avialable in your client.
All Program-->Ascential-->Online documents.
Else search this forum.

If severvice pack is already been installed, then "dsclient_xpsp2" will be the one required for you.

Is "dsclient_xpsp2" the path you are mentioning about?

As said earliar, "date2" cannot be key.
Avoid Hashed file.
Lookup on "Key".
You will get multiple match, have a constraint as "date2<=date1".
Map the id in derivation.

Check if the wrapper stage that is used in the job, is open for editing simulteneously, while you are trying to compile the job.

"date2" is not required to be a key other than "=" operation(Exact Match) .

Hi karthegx,
When you create a post, Pls have more relevent topic like "Job Log/Report in Sequential File" given to that. That will help person who answers the post, as well as those who search forum later.

Do lookup on the "key" and in constraint part, have your required condition "date2<= date1 ". And in derivation Map the "id" field.
You can avoid hashed file. If you want you, you need to mark both "date2" as well as "key" fields as key. Where in you are actually looking at only "key".

To find the records which are not in Source, you need to do a look, it can be either through Lookup Stage or Join stage as Arnd saind or recreate a table thorough a query INSERT INTO ....(SELECT ... FROM <target> IN(SELECT ... FROM <source>)) as suggested by Siva.

Try to check, with having two stages, One with select query, and other with to Insert the selected Data.

1. Map the target to the decimal(10) datatype.
2. Derivation - Input.Column[1,4]
Still there are several ways. One of the simple way is this.

Assign APT_STRING_PADCHAR to a space ' '. As suggested by Ray.

Actually, Daily many challenges.

What is spoiling you motive of parallelism.
If SeqA and SeqB are connected to the Sequencer, they both will be called parallely.
And followed by the SeqAB.