DSXchange

The row counts can be had using DSGetStageInfo() or DSGetLinkInfo() functions. You can get total row count (across all nodes) or per-node row counts. It's all described in the help. You ought not to need to generate the row count within the job. However, if you use @INROWNUM, you will get per-node r...

Only if you mark cusrut_comp_customer_number and cusrut_comp_customer_number, and no other column, as Key.

The Join stage does support more than two inputs. However, internally it still produces pairwise joins (as would a database server) joining the next-rightmost input to the intermediate result of joining the previous pair. I think your design makes it clearer what's going on, and will probably be eas...

By far the most accurate metadata import is through the Orchestrate orchdbutil facility.

If anyone has faced this problem earlier, they probably posted on the forum. A Search would let you know without needing to await anyone's answer to this thread.

You should create your job sequence such that operations can NOT occur in the wrong order. You could also use any of the public semaphores (task synchronization locks) within your job design. These are described in the DataStage BASIC manual. Neither your question nor this answer appear to have any ...

The non-viewable character is the line terminator, converted to a field mark.

Not something I've seen. You could perhaps work around it by changing the FD. 10 XF-PRIM-REG-ID-FLD. 15 XF-PRIM-REG-ID-SIGN PIC X. 15 XF_PRIM-REG-ID PIC 9(02)V9(06). 10 XF-PRIM-REM-ID-FLD. 15 XF-PRIM-REM-ID-SIGN PIC X. 15 XF-PRIM-REM-ID PIC 9(03)V9(06).

See, one CAN hijack one's own thread!

Just have the CFF stage "normalize" the repeating group. The CFF stage itself can generate the multiple rows. Then run the single output through a Transformer stage to filter out those occurrences that have the "empty" value - did you say it was all zeroes?

Check whether there's an extra line terminator at the end of the file. If so, pre-process the file (for example with sed) to remove it. Examples have been posted in the past, for which you can search.

Can you be more specific about what you mean by "an address is valid or not"? For example, do you need to go to the full extent of checking against a postal certification database (which is obtainable for some countries, including the USA, with QualityStage)? Or are you only seeking to verify that t...

The easiest way to get the job log into a text file is to choose Print from the Director's Project menu, and check the Print to File check box.

What is the highest legal date in the database? Have you supplied a date later than this?

It means I'm now having to spend an unconscionable amount of time on DSXchange.