DSXchange

You are saying the same thing over and over.
Tell me this, how will you handle the following:
What if both are not null?
What if both are null?
and between the two, which one take precedence (i.e, which one to check first)?

In this case you do need quotes around your date.

Your code looks fine. Is there something thats not working?
Have you considered the scenario in which both circuit and phn are null? Then what?

Can you post your sql query.

Minhajuddin wrote:But I don't think that adding a Copy stage between your DB Stages would improve Performance.

Right. The copy stage is intended to make copies of the input stream. If that is not the intension then un-necessarily do not stick in any stage.

How much is the memory (RAM) on this particular machine? And what is the difference with other machinces?
If there is no difference then try to cut out some programs that are running in the background to release some memory.

Look at the parallel function "DateFromDaysSince". You can give in a negative number say 730 (+1 for leap year) to the function along with your incoming date. It will give you a date 24 months ago from current date.

Ashish.ds, did not mean to be rude. But posters looking for answers for interview questions, are just frowned upon in the DSX community. Even if its just a simple, single question. You had a bunch of them and hence my reaction. I realize that my response was a little harsh, keeping in mind that it w...

Welcome Aboard You have posted in the wrong forum. This forum is for parallel job specific question. You hardcode the value for the key while building the hashed file to say 'X'. When you read the hashed file, hardcode the value 'X' for the key and for each incoming record, the hashed file will be r...

Use the following query and thank Kim (kduke) for it. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(@RECORD,'Your file/table name',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_JOBS...

I have heard that 8.0 has a plugin/methodology to access it directly. In earlier versions, no. But a combination of java packs and webservices might work. I access data from AD at my site. What I did was to do an ldap/csvde call in a windows bat script. Spit out the result to a flat file and then ft...

Libraries for your login ?
I did not get that question. Do you mean that you have the right credentials or you want to make sure your environment variables, relating to DataStage, are set up properly?

how are you running it? There must be a file a.out created when you compile your code. Execute a.out
Is that what you are doing?

Copy stage, like its name, just makes copies of your input. It has nothing to do with your source and target. It will make copies regardless. Its performance is pretty good too.

Sure. Use a command stage to spit out the results in a sequnce job. Use <<stagename>>.$CommandOutput as the derivation for a parameter in your job activity. Define this job parameter in your sql select within hashes.