DSXchange

Job parameter seems to be indicated then. For example:

Try "escaping" the single-quote characters ( \' ).

Use Mod() function with Random() function. For example Mod(Random(),100) will return a number between 0 and 99. For a 10% random sample, use Mod(Random(),100) < 10 in a constraint expression. The constraint expression could also include a restriction on @OUTROWNUM.

There are options in the Usage section of the Connector to warn or fail on metadata value/size check failures.

samsuf2002 wrote:You can use FMT().
Do a search to find out how, based on your requirement.

Fmt() is not available in Parallel jobs.

Provided the target is a string, you can use string functions to pad with leading zeroes. For example:

That changes the question.

Field delimiter should be none.

IBM says they're better because someone in IBM says they're better and the sales folks pick up the cry. Connectors make use of the Connector Access Service, which is better attuned to the architecture of Information Server. So, while there's not a whole lot of difference in DataStage alone (yet) apa...

What is the rule that determines whether an input row ends up in Group 1 or Group 2?

Your SQL is only selecting two columns. XRF_CUSTOMER_T.N_CUST_DWID and XRF_CUSTOMER_T.N_CUST .

This is a long an complex discussion. Weights (agreement or disagreement) are assigned to each field based on their "information content", or rarity within their own domain. Both m-prob and u-prob are used in this calculation. Logarithms are used to make valid the technique of adding colum...

Show us the SQL.

Have the Sequential File stage read the file with each line being a single VarChar field, then parse that in a downstream Transformer stage.

(This is actually more efficient, as the parsing occurs in parallel rather than in sequential mode.)

That's because the Transformer stage constraint expression is not written in SQL. (You can use SQL-like expressions in the Filter stage.) The expression you require to pass rows in which "test.com" does not appear in the to_transf.add field is: Index(to_transf.add, "test.com", 1)...