DSXchange

What language are you guys speaking ???

Probably not, Grandfather

Well, characters like that have been called "special" since I started working in IT back in 1984 1984 huh. I was still carrying around a sippi cup. So many special character, that too in every column is weird. I havent been in IT for as long as Mike but even I can say that you need to inv...

Your assumption is correct.

The sql I am giving you has to be run in uv shell or in the adminstrator. For category: SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE NAME = 'your jobname goes here'; For any string or table name or file name used in jobs, the following query will give you that (thanks kduke for it) S...

Look into sort stage and filter stage.

Look into Sequencer stage.

The answer lies in this statement

Devendrudu wrote: I want only top 5 Total_sales_amount customers.

I gave specifics of data archiving. If you want to understand the concept, google it.

Involve your DBA. This usually comes under DBA tasks. What we do here is have an archive flag column. The dba runs a scripts and sets the archive flag which he then puts in history tables in a seperate schema.
There are other ways of doing it as well.

Another way to do it would be to call the stored proc and assign the value to an environment variable. This way you can leverage the run number in all your jobs.

I once attempted, poorly, to accomplish this. Did not use it and have not gotten a chance to enhance it either. You are more than welcomed to see if it can provide a starting point. The code lies here.
I would advise to get rid of the malloc() command as it provided a lot of grief in pxEreplace().

The routine will change. Look into KeyMgtGetNextValueConcurrent()

Yes.

If your input is a flat file than IsNull() will not work. Check for spaces as well.