DSXchange

Hi Ray,

Apologies for not let the version correctly it is 7.5x2.Yes you are right that is what is happening.


Regards,
Bala.

Hi, I am trying to change the Quote character from " to 000 in a sequential file stage(target).When i do this and compile the job again the following error message appears. Active stage has no output columns I understand this error message but the column definition automatically goes off.I am n...

Hi, I have a job which is running in multiple instance.In sequence I am calling the job in two different job activity(parallely) Eg:-My Sequence design looks like this JobActivity1--->Job A(Multiple Instance)--- Job Activity2---->Job A(Multiple Instance) When I execute the sequence it gives an fatal...

Hi, I am having a warning when I use reject rows in the constraint fields in the transformer. CDC_version1_1..Sequential_File_30.DSLink29: 31357 Rows rejected. When I try to the fill the constraint with the filter condition(say opposite of what I have mentioned in my previous constraint) I am not ge...

Hi All,

Anything can be done to solve this or we need to do fresh installation of DS or an upgrade.

Regrads,
Bala.

Hi, I have searched for it and i have got it for unix.We can edit the file dsenv and make the corresponding entry in it restart the datastage services.But this is Windows where can we set the parameters. Note:-There is migration(Oracle to Sysbase) in the database.Database(sybase) was installed later...

Hi All,

Any inputs.......

Thanks in advance.

Regards,
Bala.

Hi All, I have installed Datastage Server on Windows 2003. There is Sybase(12.5) database installed in another server. Sybase Client is installed in datastage server. Datastage clients are installed on differnt machines ODBC drivers gievn by ascential are installed in datastage server. When i tried ...

Hi, We could import the metadata through Plugin as well as through Orchestrate schema definitions but not through ODBC. . My odbc.ini file for one Oracle user(user1) looks like this [ODBC] IANAAppCodePage=4 InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc Trace=1 TraceDll=/home/dsadm/Ascentia...

Hi, Thanks Ray for your help.It working fine now.We could import the metadata through Plugin as well as through Orchestrate schema definitions but not through ODBC. . My odbc.ini file for one Oracle user(user1) looks like this [ODBC] IANAAppCodePage=4 InstallDir=/home/dsadm/Ascential/DataStage/brand...

Hi Ray,

My aim is to check whether the connectivity to Oracle 10g database is working fine.But i that step i am facing this problem.

Regards,
Bala

Hi All, I am getting the Error.Unable to intialse plugin when i try to import metadata through DS manger(plugin metadata definitions) Databse:-Oracle 10g OS-Unix(hp) DS:-7.5 My dsenv file looks like this. ORACLE_HOME=/u00/app/oracle/product/10.2.0; export ORACLE_HOME ORACLE_HOME=/u00/app/oracle/prod...

Hi uslaslam1us/Ray, Thanks are lot. I have got a fair idea. But my curiosity to strengthen it I am continuing it. The queries are diffrent but each touch the same table. I'll give examples. query1:-Select Eno from Emp where sal>5000; query2:-Select Dno from Emp where sal<5000 ; so i can do this in t...

Thanks Ray, So i can go with any approach.Pefromance wise it works the same way.Just to clarify one more point One the first occasion i am touching the database twice. second one I am touching it once but fetching more rows and giving extra work to the datastage Engine.Any comments on this. Regards,...

Hello Ray, Thanks for the response.I have to re-frame my question I am not doing a sparse lookup.My question is can i create two different lookup files for diffrent userdefined queries or one dataset and use the filter condition in transformer stage or filter stage to yield optimised performance.The...