DSXchange

Lol !! They are also not sure how to proceed on this

Hi ,
While login into datastage 8.5 getting a error message like "Failed to authenticate the current user against the selected Services Tier
CORBA TRANSACTION_ROLLEDBACK"
I am not sure how to fix this error.
Please help me.
Thanks in advance.

Hi ,

Possible with datastage 8.1 version , using connector use the longvarbinary type in source same at the destination .

ksk

SrcHashFile.LnkOtSrc: WriteHash() - Write failed for record id

What part are you having a problem with? :? Create two job parameters and include them in your SQL with pound/hash signs like normal. You'll need to create a mechanism to store the last value then retrieve and increment it properly, of course. That could be as simple as a flat file that you read an...

You can parameterize the query limit offcourse. Check on the records how would you like to filter that into six groups based on which you may use the query limits in that. You can create that parameter in the Job properties . Abhijit Hi I need like this i have parameter start limit and end limit th...

Hi, I have designed two job which fetches data from external database to sequential files. In another job i have used those two sequential file. one as source and another one as reference, i have used like sequential file to hash file then to transformer in reference side , and source to transfomer ...

hi,
i have a job which fetches 8 million record so i have planned to limit the row by using query limit . so for this i can use a parameter which will fed the limit 6 times .so please help me to do this.
Thanks

ray.wurlod wrote:What happens when you invoke on-line help from within the stage? ...

is it related to oracle partition methods?

How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ... Is there is any other way without using jobs ? :idea: Don't have the index in the first place ? Is that an interview question ? What types of index do ...

Hi,

What is the use of partition name property in bulk loader

Thanks

ray.wurlod wrote:How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...

Is there is any other way without using jobs ?

Hi,

The performance of bulk loader will increase if the destination table has no index so how to drop the index before bulk loading

Thanks

Hi,
I have extracted the data from oracle to datastage(oracle stage) .
but there is a change in the column data type.
when i extract a column of date type in oracle comes as timestamp in datastage why?

Thanks in davance

Hi,
I have created a rangemap file .
Please say how to use that rangemap file.
when i execute the job i have some error called
"cannot open rangemap file"
whether range map file has any extension i have specified the extension as .txt

Thanks