DSXchange

... but you will need a separate Column for Calculation for each calculation - just as you would if you were doing it in SQL or using any other tool.

No. You have to design that piece, perhaps by looking for the explicit column header values (since your columns are all defined as sufficiently large VarChar to handle the column headings, no row will be rejected).

Welcome aboard. First of all, it's a sequence, not a sequencer. A sequencer is a component that you might use within a sequence. The simplest approach is to have the job that performs validation generate a warning when a problem is found. The sequence can detect this via the $JobStatus activity vari...

Learn how to decode Oracle error codes, for example using the oerr command or the (Oracle) error messages manual.

Welcome aboard.

The simple answer is that you capture the requisite information - typically in a Transformer stage (since you have specified server job type) - and direct the reject rows and/or diagnostic information into Sequential File stages.

Don't take your eye off the "Cloud" ball. "They" are investing hugely.

When reading from a Data Set in a grid environment, a virtual and read-only Data Set is constructed using the nodes that were used when the Data Set is written. That information is stored in the Data Set descriptor file and can therefore be re-used when reading from the Data Set. There is also an op...

Try these two techniques.

• Use forward slashes in the pathname rather than backslashes.
  
  Use a UNIX-style pathname that does not include a drive letter.

It's already in the Transformer. RT_BP1116/JOB.2013283459.DT.1533610691.TRANS13 is a file containing the code generated by compiling a Transformer - as to which Transformer stage it is, you will need to examine the generated code, which will contain a comment that includes the stage name.

Be more specific about what "not working" means. I have no problem with it. Tell us what your property settings are, what output you expect to get, what the file names actually are, and what output you are actually getting.

You don't need File Pattern to read one file. (The file name could be a job parameter.) However, it will work to use File Pattern, provided that the pattern matches one or more file names. It would appear that your pattern does not (or lacks a directory component to the path). Please advise the prec...

Is there a file called .Type1 in the RT_SC1369 directory?

I disagree. LOGNAME is the name used for login. Historically there was an eight character limit on system variable names, which shows up in this particular example (LOGINNAME is nine characters).

Welcome aboard. When's the interview? As a general rule we at DSXchange do not answer what are patently interview questions, based on their generality . However, here are some answers that may or may not please your interviewer, since this is your first post. There are at least two ways to make the ...

Further, to discover the existence of a table or view, you may require SELECT privilege to the system table that records the existence of tables and views.