DSXchange

Cast individual cols before concat.

What if your sequencer was started on 23:59 hrs and was found running during 00:00 - 05:00 period ?

No. Decode is just another function in Oracle.

One of the following two statements must be valid.

1.) The data is incorrect - as you have duplicates in one and you expect unique values in the output
2.) Your assumption of uniqueness is incorrect.

Find which is one is true and design accordingly.

I wonder how the post from chullet appeared before manojmathai even though it was posted much after that !!

You will need to parse the file 2 times.

You can use job control and native db connection to do it. The only diff will be that the db is shared and can be accessed by various methods.

How did you check that the DS is up? Maybe someone was logged in when it was brought down.

Sometimes the admin people get worried about the DS jobs and kill the process.

Is the question to get the message given the id?

Search the forum. You will find lots of methods.

That is because your lookup source has dupl keys.

You need to decide whether it is valid or not and set accordingly.

DataStage does not delete any log unless otherwise set to do so.

Search for DSGetJobInfo for more information.

DataStage does not interpret the values when you view it.

Check whether you are viewing the same file.

Firstly, why do you want distinct?

If the source is from a db, you can use SQL join to get the dups.

Otherwise, write the count key in a ds and reference it in the job.

There are lots of other options depending on your requirement.

Or must it be



But note that you are dealing in parallel mode.