DSXchange

Narasimha, as i said i cannot use the Sybase stage because of it not functioning well and i have to use ODBC stage only Perhaps if you explained what in the heck 'not functioning well' means something can be done about that. :? If it's the performance drop you mentioned in the other post, I doubt y...

Yeah got it

Date_Archive>='dateadd(day, -5, getdate()) '

chulett wrote:Got nothing to do with ODBC, it's all about your database. ...

Sorry about that, its data from sybase thats being extracted using ODBC. I need to add that clause to the select statement.

Hi guys, how can i write the following where clause in ODBC stage.

'Date_Archive>=SYSDATE-5'. Does SYSDATE work in ODBC? Please let me know.

Thanks

Sybase variables need to be set in the dsenv file for it to work properly and I bet the client needs to be installed on the datastage server. What about the DRS stage? What is DRS stage? Sybase variables are set in the dsenv file but the performance is very poor. It starts off at 100rows/sec and di...

Extracting data from SYBASE using ODBC stage is very slow (My experience with it) also there are not many options to optimize in the ODBC stage. If you really need to optimize you need to ditch the ODBC stage. Narasimha, as i said i cannot use the Sybase stage because of it not functioning well and...

ray.wurlod wrote:Can you try the same SELECT statement using a Sybase OC stage? ...

The problem is Syabse Stage doesn't seem to work properly here, i mean at where i am.

Hi all, i am etxracting data from SYBASE using ODBC stage and loading it into Oracle. The sql statement in ODBC is a simple select statement with no where clause but when i run the job it starts off with 100rows/sec and falls down to 30rows/sec and lower. For 50k+ rows it takes more than 10 minutes....

chulett wrote:Sure. Just 'Load' it or drag the metadata to the link from the Repository Browser. Or 'Propagate' the column definitions through a Transformer. ...

Thanks chulett

Hi, can a Oracle table definiton be used for a sequential file? The sequential is going to be a new file which i will create. The thing is i need to drop the same output to both the oracle table and a flat file.

Thank you guys.

Seq File columns: Sample(non-key), Sample_Number(key)
hash File column: Sample(key).

I linked Sample(non-key) from SeqFile for the Key expression.

Narasimha, if i remove the constraint, rows which dont match are also being output to the target

Chulett, it is not literally what i have in my key expression but the constraint is like Link1.Sample=Link2.Sample. where Link1 is for Sequential File and Link2 for hash file.

Yeah the key expression is like what you have mentioned.

Thanks

Hello Everybody, I am doing a look up against a flat file. The only column in Hash file is 'Sample' which is obviously the key. On the flat file i have Sample_Number as the key and i also have the Sample column as non key. The key expression is Sample.FlatFile=Sample.HashFile. The thing now is, even...

Hi all thanks much for the solution and suggestions. It is not absolutely necessary for me to use the necessary subroutine. KrazyKoolRohit's idea did work excellently.

Thanks once again :D