DSXchange

Just be aware that, the settings can be made project wide or in the job wise. If the variable is included in the job's Environmental variable and a new value is been set, it is limited to that job.

Hi Havoc, The option that you found out is more simple. You can just group by based on Parent Dept Child Dept, and get the max(LEVEL) with order by max(LEVEL) during extraction. You can just concatenate subsequent row until you find a change in value using stage variable. Though the LEVEL is in reve...

Is the data flow in jobs increased lately?
It might be due to JobMonitor in parallel jobs.
Try to change the time based monitoring to size based.
This is done by unsetting the APT_MONITOR_TIME environment
variable and setting the APT_MONITOR_SIZE variable to a suitable number,
e.g. 1000000.

ArndW wrote:DS server, not the client.

Arnd, It should be Client's and not server's authentication, isn't?

In this case, you need to either Basic Transformer to call the BASIC routine, or need to compose a C Routine.

I never did, but it should be doable. If you source is in sequential file, you have no other choice. If you have other options, you can try to convert it into lookup fileset. It again depends on the size of the file that you are going to use.

ray.wurlod wrote:How to do every second comma using tr command?

Yeah, I didn't noticed this.
You can use

narasimha wrote:How is SCD related to AWK

Narasimha, I guess you got the point. Because, I couldn't find any SCD in awk.
May be he is referring to sed

Try the JobB with Dataset-->TX-->Dataset or DataSet--.TX-->Seq file.
I hope you wouldn't be getting this error. Focus on the Oracle Stage, if you are using any User defined SQL, which calls any oracle function, or any external SP. You can post the same here.

You can use translator from unix as well

DUMP_SCORE might also help.

Check the Filter command from the command prompt, if it gives the output to the console.

What are the inputs?
How the field Indicator is decided upon? ie., how the cound 1,2,3 or 1,2 is decided?
Answer for this vary with respect to your reply.

Hi Zac,

What is the derivation that used for that column. There may be a change were, Null might not be passed at all. Check if the value that you are referring as empty string might be a space. What is the Pad_Char property set?

What is the job desing? What stages are involved in this?
Because BigInt is not prescribed for Target Teradata stage?