DSXchange

You could also wait for a drought. Meantime you can count in a Transformer stage using stage variables. As noted, Loop variables are not the correct mechanism. Use a Loop variable for processing things within a field (though counts of those can probably more easily be obtained with functions like Co...

Are the //---------- strings part of your SQL? Perhaps Oracle is reading -- as introducing a comment, which it's not finding.

Under your scenario how would the SCD stage be able to look up a business key that occurs a second time in the stream input?

(In practice the dimension table is, at least partially, memory-mapped.)

It probably is possible from UNIX but you would have to develop osh scripting skills. I don't claim to have these.

If you capture the generated osh from a successful DataStage job you could use that as the osh script.

ODBC connectivity from a UNIX/Linux server is established by editing the .odbc.ini file in the DSEngine directory the uvodbc.config file in the project Full information is to be found in the various Connectivity Guides in the manual set. If you don't have manuals ready to hand you can also get the i...

The master record is the one with the highest aggregate weight when compared with itself. That is, the one with the greatest information content in all the fields mentioned in the Match rules. Where there is more than one record with the same weight in a block, the one selected as master is indeterm...

Right click in the background, or press Ctrl+T, and choose Filter. The rest should be intuitive.

To work properly the SCD stage needs, in theory, to get the current row in to the dimension table before the next row is processed. Stay with upsert, array size 1 and auto-commit.

IBM InfoSphere Information Server Administration Guide, Chapter 6 (for version 8.7), section "Engine security configuration".

Look in the Reporting section of the Environment Variables using the Administrator client. You will find there the environment variable(s) you require.

What's difficult about it? What have you tried?

Search the forum for "vertical pivot" and adapt one of the techniques.

Anything in the parallel Transformer stage is per-node.

Use a DataStage job.

That's really a different question and should be a new topic.

Don't know about fixes and patches yet. You initial problem is that you have not set up Engine credentials for user dsadm.