DSXchange

Ray, RTI components are still a part of SOA, isn't?
Getting RTI license for the current server version will also do the required stuff isn't?

There is a command line option 'dscc' from client where you can compile programatically. Certain version of Datastage supports Multiple job Compile. Optionally you can export the job with executables, so that, you dont need to compile at all. But converting the Project into Protected, you can make t...

Dont you find in Install and Upgrade?

But SO_NUM=338520 not in d1?
What you mean by compare? Could you explain bit more on that.

All the three sequential files are of single process which runs in sequential mode and the transformer runs in parallel mode and hence with processes.
Total of 5 processes.
Three links and hence, 3 virtual dataset.
Here it has 4 stages mapped to 4 operators. It may not be one to one at times.

Ask him (our you) to schedule a job or any script using your user id, from command prompt. If that succeeds, it proves, your user id has permission.

Do you get any warning pertaining to that column?

rachitha wrote:Update Action: Clear the table, then insert rows

Will this work?

It again deletes the whole table and inserts the new rows.

If you notice in output, for SO_NUM 620421, value for FEP will be SUM of FEP values for SO_NUM 620421 in table X, with latest values for other attributes 929.907 is just the sum of all FEP from the source table. To find the sum, use Aggregator, and use SO_NUM as key and find the sum of FEP, Max for...

My mistake I was under the impression, that the sqlcode is propagated only when RPC is turned on. But its not the case. As mentioned, Copy stage can be used as an intermediate stage to drop the column. By the way, if its reject table, adding Sqlcode as a part of metadata will add more information on...

To my understanding, you are extracting from a table and partitioning to 3 dataset based on some condition. And you need to find MAX of some value existing in each group. So was the suggestion of using Aggregator stage after the Transformer stage. It will be better if you could give out some example...

Yes, Hash partition on the keys fields before sort and maintaing the SAME partition to the CC stage will out expected result.

samsuf2002 wrote:How we should handle the dups in look up stage?

In Lookup Stage Condition page, select the Link name where the lookup is entering in "Multiple rows returned from link" option.

Truncating table wont work, becasue you ll end up in loosing other key which are not in you current list. Now its time to accept the existing design. One improvement that you can make is, no need to aggregate to get the distinct list of keys, anyways you can use "Delete exisintg rows only" option wi...

Sqlcode is unseen column, which will be propagated only if RCP is enabled.