DSXchange

please tell me way to find the solution. Call Support. Are you thinking you will be doing any 'transformations' of the LONG data? If all you are doing is moving this data from one instance to another, that certainly doesn't need to be a DataStage task. As others here have said, just because DataSta...

What are your source and target datatypes? NUMBER? NUMBER(38)? Why not try manually changing the metadata to whatever you feel is appropriate based on those types and your data?

I doubt it is supported. Check the pdf documentation for the stage. The OCI stage on the Server side - for example - lists in the 'functionality not supported' section: Support of Oracle data types such as BLOB, FILE, LOB, LONG, LONG RAW, MSLABEL, OBJECT, RAW, REF, ROWID or a named data type. So it ...

It's not required at all. The column names defined in the stage are, in effect, the 'aliases'.

In Server get the record count and Sort the data descending on the value in question. Constrain your output to the 'top 10%' of the records.

I'm assuming he's specifically referring to the old ORABULK stage, which I don't really recall any specifics of. The newer ORAOCIBL stage in automatic mode loads data as fast as you can shove it into it.

Ack... version 6.x... never mind the last suggestion with the External Variables stage as that doesn't exist in your version. You'd need to either roll your own BASIC job control or perhaps do something with some custom routines for a non-scripted solution.

You're answering the question in the body of the post, Kumar, but missing the subject which seems to be taking this question to another level. What exactly do you need help with, vermarah? I'll wager you're currently passing parameters in your shell script (in spite of the fact I've no clue what 'D2...

Yes, either is possible. Could depend on what you want to happen with the 'good' rows after you've found all the 'bad' ones. If you are working in a database and you want your good changes to commit, do the check after job. If you don't then consider after stage. In either case, make sure you put an...

splayer wrote:What is a "here script"? Also, I would think that password "encrypted" means it won't show anywhere including the log.

http://en.wikipedia.org/wiki/Heredoc

And "encrypted" doesn't mean "invisible".

Umm... twelve?

(no guessing required)

Definitely environment related. Found the job had IP Row Buffering enabled on the Performance tab, something we don't do as a Rule of Thumb. Turned that off and we've now moved on to a different error: Transformer..Link "1": build_record() - Unable to allocate memory XML Output..Li...

If 'capture' means read and 'send' means write, sure - you can do both at the same time, meaning in one job. As noted, we'd need a better understanding of what you are trying to accomplish and what your job design looks like to be able to help. Also, I have no idea what this means: when i try to cap...

De nada.

I'd kinda lumped all that into the 'where applicable' statement.