DSXchange

Right... could be a tuning issue.... First of all, what exactly are you using your transformer for?? (I am sorry but it is not clear from your post) Then, What are teh record sizes you are loading into your hashed file??? Did you create the hashed file with all the default parametrs??? From your in...

aakashahuja wrote:Is there any data in the hashed file overflow ???

yes ,there is 7,424.000 size shows in Unix box.

yes ,there is 7,424.000 size shows in Unix box.

Its Dynamic (30) hashed file
0.3 million records are there.
Its down from initial state only.

if it is juat an @NULL constraint on a column, then what difference will it make to put the constarint in sql and remove the transformer??

I did not get your question?

Thanks.

Hi All, I have problem to load data to Hashed file from Oracle database. Its working fine before, but since last week its taking more time to load. Job Design: Oracle database(ORAOCI9)--->Hashed File stage (hashed file for Look-up for further design) I did 1) Read from Oracle ,and in transformer i s...

Hi ,
I have problem to access oracle stage,
i try to configure .ODBC.INI
but i think there SID wrong define for DSN,
so can some one tell me how should i find out the SID,
i know little about tnsping ,but i dont know exact syntax.
Thansk.

My problem is solved,i used DSSetUserStatus routine method.Thanks All.

Ok... details, please. You've never said what exactly you are executing in the command stage, postd the script, what kind of information you are returing, how the parameter is defined in the job it needs to be used in... nada. Let's start there. As much information as you can stand regarding what y...

so what is solution for this? Please tell me. Thanks I don't believe you can use functions in expressions in your release, pretty sure that wasn't added until 7.5. From my 7.5.1A readme: - Expression Support BASIC-like expression syntax has been expanded and is now allowed in most job sequence activ...

I insert that value expression using Insert parameter value Tab.

[You are giving these expressions in the expression spa ...[/quote]

I already tried that one and right click not able at that time,i using 7.1 version.Also when i type that code its shows syntax error

Add a 'www' before the dsxchange in your embedded post. What is your job design? What did you type in the expression editor? i wrote this first Execute_Command_0.$CommandOutput it give error Sample_Seq..JobControl (@Job_Activity_1): Controller problem: Error calling DSSetParam(Sequ), code=-4 [Param...

Hi ..
I have a same kind of problem ass swades had,
I gone through following link,

http://dsxchange.com/viewtopic.php?t=10 ... bc9304eb87

i used that code for value expression but i give me error that expression is not right, i am using 7.1 version.

plz help me Thanks.

Hello All..
Can somebody tell me what is difference between Datastage routine,function and how to call store procedure in datastage..
thnks...bye..

what kind of 3rd party tool available for Datastage and what is use for that..?