DSXchange

A few million rows (being selective about the columns - only the ones you need) may well fit in memory and be amenable to normal, local lookup, which is fast. Use an always-on job so that the reference data set remains loaded in memory.

If your passwords were encrypted using DataStage, then you're still officially out of luck. No documentation of that algorithm is provided by the vendor. That said, some people have gone to the trouble of analyzing it, and have posted their findings here. Note that this is technically illegal and, i...

You're out of luck. It's not possible. This is not a limitation of DataStage BASIC - it's a limitation of any programming language. You need to call the correct decrypt function (the one associated with however the password was encrypted).

kottinaresh wrote:I need to implement atleast one quality stage in my upcoming project.

Why?

No, because before you can understand what these are you need to get a reasonable understanding of how the parallel execution engine (sometimes called Orchestrate) works. This you can read about in the Parallel Job Developer's Guide, Chapter 2.

8.5 - 7.5 = 1.0


From the developer's perspective it's not much changed, apart from a heap of new toys.

From the administrator's perspective it's a whole new ball game; a totally different, service-oriented architecture.

You'll find plenty of information on the IBM website.

pandeesh wrote:Is there any other way to achieve this?

Start by not hijacking a thread that is about a totally different problem.

Where will we find the partitions per enabled for a job? Everywhere. Parallel execution is enabled by default in the parallel Transformer stage. Open up the stage properties. On the Advanced tab you will be able to change the execution mode to Sequential. Do consider using a server job for this tas...

You also used incorrect function names, and did not concatenate them. The correct equivalent for your expression is Convert(Char(10) : Char(13), "", InLink.COLNAME) However there is a cost in evaluating the Char() function. More efficient would be to create a stage variable, let's call it ...

or

Welcome aboard.

The ReadBlk statement can read an encrypted file. What it can't do is decrypyt it.

How was it encrypted? You need to invoke the companion decryption utility to decrypt the file's contents.

I guess we need to know a little more about your job design.

This is the point where you involve your official support provider. Maybe you can make sure you have the correct version and bittage of WAS installed.