DSXchange

Dsnew

Thanks for taking the time and responding Craig.

If we use same ODBC Stage with multiple Links does it considered as one session or does it spawn multiple sessions ?
I Like your second solution is a good one too.

Dsnew

Hello all, I have a situation where in I am reading from source (Mysql) with an ODBC Stage. Also populate a hashed file for lookup in the same job using a different ODBC stage (Same Source) As expected the main ODBC Stage waits for the Hash file to be populated before it starts processing the rows. ...

Dsnew

After running DSX_Cutter.pl Does anybody get a special character [?] before the .dsx

Code: Select all

 Example DSJOB_JOB_NAME?.dsx

or is it just me

Any suggestion folks ?

Dsnew

Thanks narasimha and chulett. That did it! Appreciate your time and knowledge.

Dsnew

I am facing an issue with reading and writing dates from/into Oracle My job design Source_OCI_Stage -> Transformer -> Target_OCI_Stage 1. The Oracle table has the datatype as DATE 2. OCI Stage has the column defined as TIMESTAMP When I click on view data I get the error ORA-01821: date format not re...

Dsnew

Ray - You are the MAN! Thanks much :D

Dsnew

Ray,

Thanks for the constant support. We get 1 again. Probably because both Stairand airhave a trailing "+" in them

Code: Select all

TEST #1
*******
 
Arg1 = Stair+1;air+2;
Arg2 = air
 
Test completed.
 

Result = 1

Dsnew

What he means is if you have your search string as a sub-string elsewhere in your name/value list and that substring appears prior to that actual search string e.g. Stair+1;air+2; With search string of "air" would get you the 1 and not the 2. You can for the most cut this off by searching...

Dsnew

It works fine now! Not sure what went wrong with me last time.
Thanks you so much Ray!!!
It worked for all scanario for me, can you please let me know the limitation you said this had, so I can be aware of it.

Dsnew

Ray,
I used your code (latest). I get similar results

Code: Select all

TEST #1
*******
 
Arg1 = Austin+Texas;Blue+Sky;air-baloon+ride;Laptop+Pad;Grass+Green;Deep+;
Arg2 = Blue
 
Test completed.
 

Result =

vkhandel, Thanks for you code, I have not yet implemented it, will let you know how it goes.

Dsnew

Ray,

Thank you for the quick response.

Code: Select all

TEST #1
*******
 
Arg1 = Austin+Texas;Blue+Sky;air-baloon+ride;Laptop+Pad;Grass+Green;Deep+; 
Arg2 = Blue
 
Test completed.
 

Result =

The expected value is Sky, but I get a blank result. Appreciate your valuble inputs on this.

Dsnew

Hi all, I have a requirement to extract information from a database field which can have sample values as below Austin+Texas;Blue+Sky;air-baloon+ride;Laptop+Pad;Grass+Green;Deep+; air-baloon+ride;Austin+Texas;Blue+Sky;Laptop+Pad;Grass+Green;Deep+; Table+Chair;Blue+Sky;air-baloon+ride;Laptop+Pad;Gras...

Dsnew

Hi all,

I had tried it before, but out of curiosity, I went ahead and added both server and parallel jobs into the same Job Sequence. The sequence ran successfully.
Would you say it is not a good practice? Or is it forbidden to do it?

Dsnew

Thanks for your inputs.

Dsnew

We might migrate from 7.5 to 8.1 or the latest version of Datastage as of then, in a few months. I dont have the intallation documents. Can anybody confirm if Metadata repository can be installed on Oracle 11g. Also, what is suggested - DB2 or Oracle ? Do we need to buy licence for DB2 ? If we choos...

DSXchange

Search found 90 matches

Read from a changing table

Error while viewing data from OCI Stage

Extract data from a Database Field

Combine both Server and Parallel Jobs in the Same Sequence

Metadata repository and 11g