DSXchange

Silly Me... I hardcoded i value inside get method for LinkedList.

Hi all, I am trying to use LinkedList for loop inside process() method. I was able to compile the java code fine and using a Java Client Stage to invoke the class file. So when i use LinkedList for loop inside process() method, its keep repeating the first Record of the LinkedList for the rest of th...

No Paul, They are on different hosts

Yes that's Right Craig, I am loading the same table in separate databases

Hello all, We have a multi-instance dataset to Oracle job which runs slow if I run it against all database instances in parallel. However it runs quite fast when I run it against single database instance using bulk load? My job design is pretty straight forward. DataSet ----> Transformer ----> Oracl...

Hello All, We are trying to pull 250 Million Records from AS400 (DB2 I-Series), but ODBC Connector(to AS400) is pulling only 2000 Rows per Second. I played around transaction size and array size with no luck. I tried to figure out the bottleneck by directly using flatfile and dataset as target, and ...

I know its an old post, but just thought of providing solution to the issue. I was facing the same issue with slow running job with inserts/updates/deletes, obvious choice was plsql to do all 3 in one shot, but unlike case statement mentioned in previous solution,i tried merge update/delete/insert, ...

Thanks Kashyap, you are awesome..I was able to do this with Stage Variables though... StageVar1 - Converted all '.' and numbers to tilda(~) using convert function. StageVar2 - Used index function to get the position of 6 consecutive tildas in StageVar1 Variable. Used that position pull the substring...

Hello all, We need to extract year and quarter from a string. Please find our source string below. Source String may contain below values. ABCD1998.3EFH.GHAI.678ABCD.EF 1998.3ABCD.EFH.AJG.SS.123SSS...SSS... ABC.DEF.EF345GH.124SJLAS..1998.3 We need to extract the 1998 as the year from above 3 strings...

Hello,

Reading it as String in Schema file and loading it Number Field in target (Implicit Conversion)....Eliminated the leading zero's. But you will see a warning in the director log.

Thanks & Regards
Koti

Hello Klaus, Syntax you provided dint work, its failing....but here is what tony might meant...this worked too... record { final_delim=end , delim=',', null_field='', quote=DOUBLE, charset='ISO8859-1' } ( field1:nullable string[max=50]; field2:nullable string[max=20]; field3:nullable string[max=50];...

Hi Tony,

May i know how you handled the decimals in Schema file for the above issue..


Thanks & Regards
Koti

Thanks Kashyap, it worked..i don't know why i dint think of modify stage to rename the column dynamically..

Thanks
Koti

Thanks Ray,Kashyap,ArndW..

Kashyap, for Column Export Stage, output column name cannot be parameterised..though input columns can be parameterised...


Thanks
Koti

Hello all,

We are trying to dynamically concatenate columns(Column names can be parameterised) and so is the output column in an RCP Enabled job.

I must use RCP. Thats the only transformation i need to do.

Any inputs are greatly appreciated..

Thanks
Koti